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 vote197 views1 answer
Sparql list all graphs
SQL
21 votes187 views1 answer
Cheatsheet for sql
SQL
1 vote189 views2 answers
Begin transaction in sql
SQL
1 vote204 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
1 vote184 views1 answer
How to change owner in postgres
SQL
0 vote186 views2 answers
Mysql decimal remove trailing zeros
SQL
2 votes199 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote253 views1 answer
Mysql sum per week
SQL
4 votes196 views4 answers
Check constraint in ms sql
SQL
3 votes214 views5 answers
No module named 'MySQLdb'
SQL