Using the New MERGE Statement in Data Warehouses

Authors

Abstract

As of Oracle 9i, there is a new SQL statement: MERGE. It allows to, with only one instruction, either update or insert rows in a table. This is especially useful in data warehouses where we update dimensions (special reference tables) periodically.

Keywords

Oracle8i, MERGE statement, data warehouses

Subject

Technical Advice - Oracle8i

Journal

Oracle Professional Newsletter, Vol. 9, #7, Farion Grove (Editor), July 2002