Oracle

Recently learning Oracle, want to improve the efficiency and legibility of the written statement, today's note is about the subquery factor words such a thingA factorial query may not necessarily improve efficiency, but it can improve the

Duplicate data can have two cases, the first: only some fields in the table, the second: Two rows of records are identical.First, the deletion of duplicate data for partial fieldsLet's start by talking about how to query for duplicate data.The

Create user;Create userExample:Create user lv identified by m215957055;Where LV is the user name, m215957055 is the user name. But note that after the creation you are not connected to this database, that you have not assigned to his authority,Let's

Today, a very strange problem is encountered, a SQL statement is slow in PL/developer, requires 9s, problem sql:SELECT * from gg_function_location f WHERE f.parent_id = ' 03000000000001 '; Table Gg_function_location has 50 million of the data andis

Start by creating a sequence (sequence) that implements the self-increment --Create sequence Create sequence T_user_seqminvalue 1--Minimum value: 1nomaxvalue--no maximum value start with 1--starting from 1 increment by 1--each time Increment

1. Configure a minimum of 2 data Group (datagroup), the Fra datagroup as the flash back Zone side archive, backup, etc.) mainly consider the IO performance problem2. Oracle Official documentation recommends a minimum of 4 disks per DG and the same

1.3.6, DuanUsed to store all data of an object in a table space with an isolated storage structure, which consists of one or more zones.1. Data segmentUsed to store all the data in the table.2. Index segmentAll data used to store the index.3.

In the Oracle relational database, let's take a look at the following question:A transaction: Select from T where ID > Ten and ID B Transaction: Update T Set id = 45000 WHERE id = 4501Two transactions are performed in the following order:A

CREATE OR REPLACE FUNCTION checkbankcard (P_bankcard in VARCHAR2)Return VARCHAR2--Returns OK when correct, otherwise returns the correct check codeIsCurval number: = 0;Total number: = 0;Everyother number: = 1;V_end number;BEGINIF (P_bankcard is NULL)

Original: Oracle create user, authorize user, create TABLE, query tableOracle creates users, authorizes users, creates tables, queries tablesAssuming that all of the oracle10g have been installed and configured.The first step: Win+r, enter run,

The following code is in the write stored procedure:For a in ( select a.svo_no,a.audit_no,a.order_id by tt_pi_model_rel a ) LOOP SELECT COUNT (1) into v_ FLAG from tt_pi_order WHERE pi_id in (a.order_id) and

Original: Oracle Common view table Structure commandGet table: Select table_name from User_tables; The current user's tableSelect table_name from All_tables; All users ' tablesSelect table_name from Dba_tables; including system tablesSelect

Do not need to keep so much, according to company requirements only need to retain one weeks.1. What is the way to automatically delete the *.log files that were backed up 7 days ago?2. Too many servers, it is not possible to create one by one

Next: Oracle Audit and Database Firewall (AVDF) IntroductionOracle AVDF InstallationApplication experiment of ORACLEAVDF in 1.HISNext, we use the configuration to demonstrate a case of Oracle AVDF to his, first after completing the previous basic

Original: http://www.cnblogs.com/netsql/articles/1745978.htmlNote the point:1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold section] to execute2. Ensure that the path exists, such as

Environment version:Oracle 11g R2Windows 7 Ultimate Edition X32Steps Directory:1. Determine the database and instance name2. Confirm the database authentication method3. Create a database initialization parameter file4. Create an instance5. Connect

Introduction to the startup and shutdown of Oracle12cCDB and PDB Databases In Oracle 12c, it is divided into CDB and PDB. Their startup and shutdown operations are as follows.1 Container Database (CDB) For CDB, the startup and shutdown methods are

How does Oracle12c connect to CDB and PDB? 1 connect to CDB Same as a normal instance. After specifying ORACLE_SID, you can use OS authentication or password for connection. [Oracle @ Ora12c/] $ echo $ ORACLE_SID Cndba [Oracle @ Ora12c/] $

ORA-01591: lockheldbyin-doubtdistributedtransaction troubleshooting Oracle errors occurred when running the batch data program yesterday: $ Tail-f INDB_ERROR_8.LOG[Time] 2014-12-01 04: 10: 31: activeAccountDeposit in oracle error: = ORA-01591: lock

OracleFGA fine-grained Audit If you want to audit the table, it is a good choice to use FGA for a certain period of time, persons and DML statements. SQL> select * from v $ version;Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit