Oracle sql merge

-- Oracle: Example for Insert or update in t1 from t2 values 
MERGE INTO table1 t1
USING table2 t2
ON (t1.CODE = t2.ID)
WHEN MATCHED THEN
    UPDATE SET t1.COL1 = t2.VALUE1
WHEN NOT MATCHED THEN
    INSERT (CODE, COL1)  VALUES (t2.ID, t2.VALUE1);

Similar codes

0 vote334 views1 answer
2020 new year
SQL
0 vote352 views3 answers
Postgresql grant alter table to user
SQL
0 vote361 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote340 views1 answer
How to find sql server name
SQL
3 votes399 views2 answers
Update part of a string in mysql
SQL
0 vote350 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote348 views1 answer
Oracle date summer time
SQL
0 vote343 views1 answer
Sql contains vs like
SQL
0 vote342 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote344 views1 answer
Describe in sqlite3
SQL