Top "Sql-merge" questions

`SQL MERGE` statement allows us to insert new rows into table and update existing rows depending on given condition.

Insert, on duplicate update in PostgreSQL?

Several months ago I learned from an answer on Stack Overflow how to perform multiple updates at once in MySQL …

sql postgresql upsert sql-merge
ORA-30926: unable to get a stable set of rows in the source tables

I am getting ORA-30926: unable to get a stable set of rows in the source tables in the following query: …

oracle sql-merge
How to UPSERT (MERGE, INSERT ... ON DUPLICATE UPDATE) in PostgreSQL?

A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT ... ON DUPLICATE …

postgresql insert-update upsert sql-merge
When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

I have a main database and a report database, and I need to sync a table from main into report. …

sql oracle sql-merge
UPDATE or MERGE of very big tables in SQL Server

I need to perform a daily update of a very large (300M records) and broad TABLE1. The the source data …

sql-server-2008 sql-update sql-merge
Oracle Merge vs Select then Insert or Update

What is faster? the Merge statement MERGE INTO table_name USING dual ON (row_id = 'some_id') WHEN MATCHED THEN …

sql oracle sql-merge
basic MERGE into same table

What I am trying to do is insert/update different versions into a product table. This is a PL/SQL …

sql oracle sql-merge
SQL Merge with inserting into the other table

I want to create a merge that will compare two tables and insert not matched values into another third table …

sql-server tsql sql-merge
Oracle MERGE - if not matched then update if condition passes

I need to merge some values into a table, updating a field when a row with the specified key already …

sql oracle conditional-statements sql-merge
SQL merge not matched by target vs not matched by source

Need a little help please, my SQL is almost non existent... What is the difference between NOT MATCHED BY SOURCE …

sql sql-server sql-merge