10g MERGE statement

The MERGE statement (UPSERT, combination of INSERT/UPDATE) was introduced in Oracle9i. In 10g it has been enhanced to include conditional INSERT/UPDATE/DELETE clauses as part of the MERGE statement. Let us use the EMP and BONUS table in SCOTT schema to illustrate the use of this statement EMP Table has got 14 rows SQL> select * […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?