10g MERGE statement
- Posted by Gavin Soorma
- On July 2, 2009
- 0 Comments
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 * […]
Read More