Skip to Main Content

How to UPSERT (INSERT or UPDATE) rows with MERGE in Oracle Database

Often when loading data you want to add new rows and change the existing ones. So you need "update if exists, insert if not exists" logic, aka UPSERT. This can lead to complex statements and conditional logic. The MERGE statement enables you to do both actions in one SQL statement. Join this session to learn how this works.

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

Workshop Info

Session Has Completed - 19 July 2022
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions