If you delete a piece of data in the table in Oracle, you can also perform rollback through the rollback operation (rollback). If you want to clear a piece of data
If you do not want to perform rollback on the table data, you can immediately
1. Use Oracle built-in functions or the effects that can be achieved by using their functions. Use Oracle functions as much as possible because their functionsAlgorithmAnd the language used to implement functions are very efficient, which is
Code
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Create Public Database Link Data Link name connect To Login username identified By Password using ' (Description
Memory Optimization:SGA consists of three parts. Data Buffer, log buffer, and sharing pool
Data Buffer: The size is determined by the db_cache_size parameter. Select name, value from V $ parameter where name in ('db _ cache_size ', 'db _
Solution to the loss of tablespace In the Oracle9i rollback segment:
Example of restoring a database with implicit parameters:
The procedure is as follows:
First, change the automatic management in the initial init. ora file to manual
1. Minute by rowidSelect * From t_xiaoxi where rowid in (select rid from (select rownum RN, rid from (select rowid RID, CID from
T_xiaoxi order by cid desc) Where rownum 9980) order by cid desc;Execution time: 0.03 seconds2. Score by Analysis
The secondary development of the email system has been completed as long as the server is mounted.
To the customer, upload the PHP file to SuSE Linux, which can run but cannot connect to Oracle Data.
The email implementation engineer is also a
The following describes how to use common data dictionaries for oracle users by category.I. Users
View the default tablespace of the current userSQL> select username, default_tablespace from user_users;
View the role of the current userSQL>
This function can split the "target string" with "specified string" and return results through the table structure.CodeAs follows:
Create or replace type Str_split Is table of varchar2 ( 4000 ); Create or replace Function Splitstr (p_string
Directory
Q1. how to create a table?
Q2. how to delete a table?
Q3. how to create a view?
Q4. how to delete a view?
Q5. how to add fields to a table?
Q6. how to delete a field in a table?
Q7. how to add constraints to a field?
This kind of vision locking occurs when the process will die when an object is deleted, and the process will also die when it is created.
My colleagues may explain the following reasons:When an object is created, it is disabled or not executed.
I. Positioning
Oracle has two major parts: development and management. Development is mainly about writing stored procedures, triggers, and so on, as well as using Oracle's develop tool for form. Similar
Program Personnel, who need to have strong
Use the dbms_random package of Oracle combined with rownum. For example, 499 users are randomly selected:
Select * from
(Select * From Busi. t_ar_userinfo order by dbms_random.value)
Where rownum:
References for dbms_random, link:
The securefile function is a completely re-designed implementation of the large object (LOB) storage format in Oracle 11g. The original lob storage format is now called basixfile, and it is still the default storage method, however, the securfile
Create or replace procedure proc6338196642095312503719 (enter the news topic varchar2, enter the news content varchar2, enter the publishing time varchar2, enter the current page number, enter the number of lines per page, and output the current
Oracle System Requirements
Enterprise Edition: Minimum CPU Pentium 200 m recommended pentiumiii 1g or above
Minimum Memory 128 M recommended 512 m
Hard Disk Space System Disk 140 m mounting disk 4.5g (FAT32) or 2.75g (NTFs)
Standard Edition: Minimum
I. Preface:After a period of storage process development, I wrote some summary and experiences during development and shared them with you, hoping to help you.
Ii. target readers:Database developers, who have a large amount of data in the database,
Copy codeThe Code is as follows: select a. f_username
From
(
SELECT/* + parallel (gu, 4) */distinct gu. f_username
FROM t_base_succprouser gu
Where gu. f_expectenddate> (select trunc (sysdate, 'y') from dual)
And gu. f_lotid = 1
And gu. f_playid = 4
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service