Oracle

String Aggrhttp://www.oracle-base.com/articles/misc/string-aggregation-techniques.php??SELECT' SELECT '||Columnlists| | ' From ' | | TBL. table_name | | ‘;‘ As Selectsql,' SELECT COUNT (*) as CNT from ' | | TBL. table_name | | ‘;‘ CountsqlFrom

Flash back area full:OS:RM-RF [Archivelog autobackup backupset controlfile Flashback Onlinelog]Eg:Archivelog autobackup backupset controlfile Flashback Onlinelog[Email protected] prod]$ CD autobackup/[[email protected] autobackup]$ ls2014_10_13 2014_

Oracle Memory ArchitectureThe basic memory structures associated with Oracle instances include:System global Area (SGA): shared by all server processes and background processesProgram Global Zone (PGA): dedicated by each server and background

In the Oracle database, a control mechanism called "transaction" is provided. Through the thing, can complete the data effective security modification operation, causes the data in the database to achieve the data consistent state. A transaction can

--Confirm Current CDB Sql> select name,cdb from V$database; NAME CDB------------------------ORCL YES --Query the current PDB basic information Col pdb_name for A30select Pdb_id,pdb_name,dbid,status,creation_scn from Dba_pdbs;select

Because Oracle has a slightly different format for adding and deleting columns, it is hereby documented for easy viewing later.1. Add Columns:Sql> ALTER TABLE t1 add y integer;Table AlteredExecuted in 0.046 secondsDescription: Added column format

1. Database in the project development, most of the use of Oracle, what 8i,9i,10g,11g, etc., has always been that the database version upgrade for the development of a system developer carcass, not what is important, I just focus on the database

Problem Description: My previous default oracle_sid is ORCL, now I want to do data synchronization, must have different oracle_sid, in order to distinguish.Now it takes just a few simple steps to modify the good oracle_sid;1. First shutdown

--Learning Job in 1.plsql--Learning Job--Build tableCreateTable Test_job (para_date date);CommitInsertInto Test_jobValues (sysdate);CommitSelect*From Test_job;--Establish the storage processCreateOrReplaceProcedure Test_jobproceAsBeginInsertInto

Oracle data dictionary and oracle dictionary I. Data DictionaryA data dictionary is a place where oracle stores database information. Almost all system information and object information can be queried in the data dictionary. Data dictionary is the

How can I retrieve the password entered by the system user of oralce? Met the ORA-28000: how to unlock theaccountislocked? The Oracle software installed a few months ago suddenly forgot the password you set. Today, I checked how to retrieve it.

Oracle Database Export and Import You need to export the data in database A to the *. dmp file, and then import the *. dmp file to database B.1. Export Database A. Enter the following command in the cmd window: Export all databases Exp username/

Plsql_performance optimization series 13_Oracle Index Rebuild Index reconstruction, plsql13_oracle 2014-10-04 BaoXinjian I. Summary Index rebuilding is a topic that is constantly under discussion. Of course, Oracle also has its own opinions. Many

Single-row functions of oracle reinforcement exercises 1. dname AND loc are separated- Select dname | '-' | loc From dept; 2. Fill the team name with 10 digits left Select lpad (dname, 10) From dept; 3. Replace the employee's name' Select replace

Oracle enhanced exercise questions Write simple query statements 1. display all information about the department table Select * from dept; 2. display the Department number and department name Selectdeptno, dname from dept; 3. display the

Adjust the size of redologfile in oracleracAdjust the size of the redo log file under rac(1) view the current log information:Select * from v $ logfile;(The path in step 2 can be seen in the MEMBER column here. The redo file name is named by

Use OracleRac11gR2's new feature renamedg to change diskgroupnameEnvironment Description: AIX7.1 + dual-node Oracle Rac 11.2.0.3Because this Rac is not installed by your own department, it is installed by the Development Department and is now

PL/SQL-stored procedures and plsql stored procedures I. Stored Procedure Stored Procedure is a set of SQL statements for specific functions. Compiled statements are stored in the database. You can specify the name of the stored procedure and provide

Install Oracle11G in WindowsUnzip the win32_11gr2_database_1of2.zipand win32_11gr2_databasesilicate f2.zip files. Note: extract the two files to the same directory, that is, merge the Components directories together. Double-click setup.exe. The

Check the script for the ORACLE warning File Check the important information within two days: Vi alter_error.sh Echo "Check Alter Error: "cat $ TRACE/alert _ $ ORACLE_SID.log | grep-E ^ ORA-\ | Reconfig \ | abort \ | Shut \ | ^ Start \ | error \ |