Oracle

Background_dump_dest displays and sets the location of the Oracle database-related logs and is no longer configurable after oracle11g, but its value can still display the location of the relevant logs, corresponding configuration parameters are

Syntax: Row_number () Over (PARTITION by column ORDER by column)In a nutshell, Row_number () returns a number for each grouped record starting at 1, where Row_number () over (order by XLH DESC) returns an ordinal of the XLH column in descending

sequence : Is an object provided by Oracle that produces a unique numeric value, primarily for use with a single primary key of a table.To Create a sequence :Create sequence seq_name//namingStart with 1//initial valueIncrement by 1//increment

SELECTUser_tab_cols. table_name astable name, Utc.comments astable Chinese name, User_tab_cols. column_id ascolumn ordinal, User_tab_cols. column_name ascolumn name, User_tab_cols. Data_type asdata type, User_tab_cols. Data_length aslength, User_tab_

--The user of the operation needs to have the following permissionsGRANTCONNECT, RESOURCE toCMIGDW;GRANT EXECUTE onDbms_redefinition toCMIGDW;GRANT ALTER any TABLE toCMIGDW;GRANT DROP any TABLE toCMIGDW;GRANTLOCK any TABLE toCMIGDW;GRANT

CREATE TABLE Egmas_count_data(Times date NOT NULL,COUNT number (+) is not NULL,System_name VARCHAR2 (+) NOT NULL,Operation_index VARCHAR2 (+) NOT NULL);--ADD comments to the columnsComment on column egmas_count_data. Timesis ' date ';Comment on

Second, the steps are as follows1. Create a DirectoryData pump requires the creation of a directory for the files and log files to be created and read, this parameter is used to define a directory, the previous mentioned data pump mainly work on the

Previously learned Oracle database notes plus some personal experience summary, share it.If there are deficiencies, please correct them.-----------------------------------------------------------------------------Database composition:Physical

/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-062.select trunc (sysdate, ' mm ') from dual--2013-01-01 returns the first day of the month.3.select trunc (sysdate, ' yy ') from dual--2

(1)Select the most efficient table name order (valid only in the rule-based optimizer):The Oracle parser processes the table names in the FROM clause in a right-to-left order, and the FROM clause is written in the final table (the underlying table,

Select Initcap (' Guodongdong ') from dual; /returns a string and capitalizes the first letter of the string;Select Initcap (ename) from Scott.emp; /start all uppercase for ename in the Scott.emp table.Select Lower (ename) from scott.emp;/all

Select Ename,&column2 from Scott.emp; Input sal;/substitute scalar;SELECT * FROM &tab;SELECT * from scott.emp where sal> &sal; 2000SELECT * from Scott.emp where Ename=upper (' &salary '); SCOTT;Define Col=commDefine viewing variablesSelect

Modifying the Oracle Database SGA and PGA sizeSize of the SGA: general physical memory 20% is used as the operating system reservation, and the other 80% is for the database.The SGA Normal database can be allocated between 40%-60% and the PGA can be

1, the computer installed Access database around 25M2. To create an ODBC data source, select OracleC:\Windows\SysWOW64\odbcad32.exe3. Open the. mdb file you want to importRight-click Table--"Export"Export ODBC Database", the table name must be all

Problem phenomenon:Alter user Scott account unlock;ERROR at line 1:Ora-01034:oracle Not availableProcess id:0Session id:0 Serial number:0[[Email protected] ~]$ Echo $ORACLE _sidxxxx[[email protected]~]$ Sqlplus/

In everyday SQL queries, we need to process the data that we want to query, and then query it in the pre-processed data. At this point we need to use the temporary table, pre-processing the data into the temporary table, and then in the temporary

--Current Date Select To_char (add_months (sysdate, 0), ' yyyy-mm-dd ') Pretoday from dual--last month current date select To_char (Add_months (sysdat E,-1), ' Yyyy-mm-dd ') Pretoday from dual--next month current date SELECT To_char (Add_months

Find an interesting question today,We know that the normal execution of select Sysdate from dual in the Oracle database can return the system time of the current host.When the system time is changed normally, the corresponding query result becomes

http://www.itpub.net/thread-1873735-1-1.html OCP Exam Experiencehttp://blog.csdn.net/rlhua/article/details/19601899 OCP Bankhttp://www.itpub.net/thread-2056436-1-1.html OCP Exam, make a record, share the experienceLogin RequiredOracle EBS Free

a transaction has four characteristics (ACID):atomicity (atomicity)Refers to the entire database transaction is an inseparable unit of work. The entire transaction succeeds only if all operations in the library are successful, and any SQL statement