Oracle Merge
转载:ORACLE-BASE - MERGE Statement Enhancements in Oracle Database 10g
# Test Table
The following examples use the table defined below.
1234CREATE TABLE test1 ASSELECT *FROM all_objectsWHERE 1=2;
# Optional Clauses
The MATCHED and NOT MATCHED clauses are now optional making all of the following...
more...