Oracle

This is the first to meet the entire library is normal, but a table query error situationA table data can be checked, but a sort of check on the errorSELECT * from Acct_daily_bak;SELECT * from Acct_daily_bak ORDER by open_time Desc;Ora-01578:oracle

Oracle Recovery method for accidental deletion of dataLearning the database, we are just learning attitude, consider how to use the database command statements, did not think about the work, if the wrong operation, can lead to irreparable loss. When

There is a new feature in ORACLE 11G that does not allocate segment when the table has no data to save space.Workaround:1) Insert a row, and then rollback will produce segment.The method is to insert data into the empty table and then delete it,

With...as ... Statement is used to define a query statement as a name and can then be referenced in subsequent query blocks. The query block with definition has a high priority when the query name repeats with the existing table name. The WITH

Oracle's Table connection supports standard notation, but there are also Oracle's special wording, which are different in some scenarios, and are recommended for standard notation, which is just an introduction to the standard syntax for table joins

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/