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

February 28, 2007

[From Builder.com]

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