Oracle

See a lot of examples on the net is basically the same, no too much explanation, for a beginner MySQL is a bit difficult, I transferred part of the following text: http://www.cnblogs.com/buro79xxd/archive/2012/08/29/2662489.htmlTarget: 1. Identify

Oracle does not have functionality such as a self-increment field, but it can be implemented through triggers (trigger) and sequences (sequence).Build a test table first:CREATE TABLE Userlogin(ID Number (6) is not NULL,Name VARCHAR2 (+) NOT NULL

Prompt for "record locked by another user" workaround when deleting data in Oracle data:1, check the database lock, the source and type of diagnostic lock:Select Object_id,session_id,locked_mode from V$locked_object;or use the following command:

function: Use an SQL statement to insert or update the operation, if there is an update, if it does not exist, insertGrammar:MERGE intotable_name t1using (Table|View|sub_query) T2 on(Joincondition) whenMatched Then UPDATEtable_nameSETCol1=..,

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determineSelect * from where inch (selectfromgroupby hascount>1 )2, delete redundant records in the

The Oracle database, MERGE into statement, often appears ora-30926:unable to get a stable set of rows in the source tables this error, as shown in:After checking, this error is caused by data duplication in the data source table (that is, the table

1. QuestionsMy environment is ORACLE11GR2, local with plsql or toad connection is not any problem, and the other machine remote connection prompts no listener and other errors.2. CausesOracle Installation Path---For example:

Whether it is a project or SQL, we usually use IN. It is easy to understand. However, IN the face of multi-layer query nesting, or the number of result sets IN the IN keyword is huge, the query efficiency will decrease linearly. In this case, we

I believe many people have encountered the ORA-02429: cannot drop index used for enforcement of unique/primary key error, the corresponding Chinese prompt "ORA-02429: Unable to delete the index used to force a unique/primary key ", in fact, the

The operations on the Oracle server are generally as follows:1) install Oracle Server Software 2) create a database (automatically created during installation) 3) configuration listening (automatically configured during installation) 4) Start an

Oracle unlocks SCOTT/TIGER users 1. Verify the current system status for SCOTT users: Select * from dba_users where upper (username) = 'Scott '; ACCOUNT_STATUS: EXPIRED & LOCKED 2. Unlock SCOTT users: Conn sys/bitservice @ ttonline as sysdba;

Oracle11g RAC construction in linux (7)6. Install the Grid and start the GRID installation interface. Method 1: Adjust the resolution under redhat     [Root @ node1 ~] #Xhost +// Authorization [Root @ node1 ~] #Su-grid [Grid @ node1 ~]

Rownum is a poor oracle database, and its order increases progressively according to the order in which records are obtained from the table. Note that because records are stored unordered In the table, therefore, you cannot obtain a result similar

1. ORA-12541: TNS: No listener Cause: the listener is not started or damaged. If it is the former, run the net start OracleOraHome10gTNSListener command (the name may be different). If it is the latter, you can add a listener to the "Listener

1. Modify the oracle system configuration file:/etc/oratab Vi/etc/oratab Orcl:/opt/oracle/product/10.2.0/db_1: Y 2. Create an oracle STARTUP script under/etc/init. d/. The content is as follows: #! /Bin/sh# Chkconfig: 35 80 10# Description:

Windows Registry Editor Version

Recommended Reference Material The detailed screenshots about installation and upgrading Oracle Server are as the following. Checking the software requirements Verify that the following softwares are installed on the system ·OS Requirements

In windows, how does one restore a damaged cluster (oracle 11g grid) by using ocr voting? Oracle 11 GB later ocr can be placed on the asm disk, and the start of the ASM depends on ocr and votedisk. Therefore, if the ocr or votedisk is lost, the

In Oracle 10 Gb, he came to scott user to perform experiments on nodes on layers 1, 2, 3, and 4 respectively: When start with is the root node (level = 1), to check its subnodes, connect by pump and emp are scanned four times (total level ). When

Test the importance of OLR in oracle 11g cluster Called an Oracle Local Registry (OLR): each node in a cluster has a local registry for node-specific resources Test 1: Simulate the loss of an olr exception: First, set the olr renam[Root @ vmrac2