Oracle

When a deadlock occurs in an Oracle database, the following processing steps can be used to resolve it: The first step: try to delete the SQL command in the Sqlplus , if you can delete the success, then everything! However, in general, when a

Sql> Show All--View all 68 system variable values Sql> Show user--Displays current connected users Sql> Show Error--Display errors Sql> set heading off--Suppresses the output column header, the default value is on Sql> set Feedback off--suppresses

--Build incremental sequence CREATE SEQUENCE lzeam_sp_loop_eq_seq minvalue 1 INCREMENT by 1 START with 1 Test: SELECT Lzeam_sp_loop_eq_seq. Nextval from DUAL --building triggers CREATE OR REPLACE TRIGGER lzeam. Lzeam_sp_loop_eq_trigger before INSERT

1.intersect to take the intersection of multiple query results; 2. Query the SQL statements recorded in the table of two basic time periods; SELECT * from Shengjibiao t where t.createtime between to_date (' 2009-7-26 ', ' yyyy-mm-dd ') and to_date ('

1. Connect the native database A. If the machine has a static ip,oracle installed, it can connect the native Oracle database. B. When Oracle is installed, the computer does not have a static IP (that is, when the network cable is not plugged

Oracle Transaction ISOLATION LEVEL Status caused by different transactions: Dirty Read (Dirty reads) A transaction reads a dirty read when another transaction has not committed a change Many databases allow dirty reads to avoid the contention of

Use an Oracle trigger to monitor an incremental deletion of a table and record it in another table. Code: Copy Code code as follows: Create or Replace Trigger Test_trigger Before insert or update or delete on test_table For each row

1, primary key and foreign keyPrimary key: A record in a relational database has several attributes, if one of the attribute groups (note is a group, can be one, can be multiple) can uniquely identify a record, then the attribute group is the

Last week, the blog wrote the Oracle Client Connection server article to solve the problem of installing on their own laptop. The original computer and server in a local area network, so each time is a remote server, but the remote is not the

First, OracleOracle Server has Oracle Instace and Oracle Database Instance is composed of memory structure and background process. Memory structure includes shared pool, SGA (System Global area). The SGA includes: Database buffer cache and Redo log

Row_number () over (PARTITION by COL1 ORDER by COL2) Represents a grouping based on COL1, sorted by COL2 within a group This value represents the sequential numbering of each group's internal sorting (a sequential unique within the group) Rank ()

The first scenario is that the returned cursor is the data for a specific table or view, such as: Sql-code: Copy Code code as follows: CREATE OR REPLACE PROCEDURE P_testa ( PRESULT out Sys_refcursor ) As BEGIN OPEN PRESULT

sys;//system Administrator with highest privileges system;//local Administrator, secondary high privileges scott;//Normal user, password defaults to Tiger, default unlocked sys;//system Administrator with highest privileges system;//local

1. Select * from EMP; 2. Select Empno, ename, job from EMP; 3. Select empno number, ename name, job work from EMP; 4. Select Job from EMP; 5. Select distinct job from EMP; 6. Select distinct empno, job from EMP;Note: Because the employee number

Oracle Database backup: --Keep the backup record of the most recent week;= = = Text:= = Start ============== Copy Code code as follows: Echo Set backup file Folder ... Set "Tbuf=e:\cway\backup" echo Sets the backup file name (named

1. Create, configure, or delete databases by running Oracle database Configuration Assistant (You can also enter DBCA at the command line);2. Building a database using a command-line approach3. Create, configure, or delete a database by running a

Therefore, in the daily maintenance of the database, if only two times to encounter ORA-01555 errors, generally ignored, but if you often encounter this error, you need to make some adjustments to avoid the recurrence of this error. 1. Why are ORA-0

AWR's data consists of two main components:1 The system load and performance statistics stored in memory, mainly through the v$ view query;2 The Mmon process periodically saves in-memory awr data to the Sysaux tablespace in a snapshot (snapshot)

SQL statements for querying and deleting duplicate records 1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to judgeSELECT * from People where Peopleid in (select Peopleid from People GROUP by

Copy Code code as follows: /*LYXXB (Cemetery information table) LYMC (Party A), DZ (mailing address), DH (tel) */ SELECT Lymc,dz,dh from LYXXB /* Remove carriage return (\b) * * Update LYXXB Set Dz=replace (DZ,CHR (13), "") /* Remove