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 vote130 views1 answer
Stuff in sql server
SQL
0 vote137 views1 answer
Pl sql join 3 tables
SQL
36 votes141 views6 answers
Rename table sql
SQL
6 votes146 views2 answers
Postgresql database url
SQL
1 vote146 views3 answers
Remove unique key from a table
SQL
1 vote189 views1 answer
Mysql is odd
SQL
0 vote144 views1 answer
How to run mysql in git bash
SQL
8 votes200 views2 answers
Oracle auto increment primary key
SQL
0 vote104 views1 answer
Connection error in mysql workbench
SQL
0 vote131 views1 answer
Case when with count and combining similar values in sql
SQL