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.

This story continues at
http://www.dbasupport.com/oracle/new...lashback.shtml