Delete rows during updates using Oracle 10g's MERGE statement

February 28, 2007

The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both update and insert rows in the same pass. It's a real timesaver for Extract, Transform, and Load (ETL) applications, such as loading a data warehouse. Rows that don't already exist in the data warehouse are inserted, and rows that do exist are updated.

The article continues at http://builder.com.com/5100-6388_14-6160479.html?tag=sc