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 vote361 views1 answer
Search mysql database for column
SQL
0 vote344 views1 answer
How to create a table in sql stack overflow
SQL
0 vote400 views1 answer
Mariadb create index if not exists
SQL
0 vote351 views1 answer
Create dump file mysql workbench
SQL
1 vote354 views1 answer
Postgres set column equal to another
SQL
0 vote365 views1 answer
Mysql select inside sum
SQL
0 vote563 views1 answer
Dublicate row sql
SQL
1 vote353 views1 answer
Tsql find foreign key references
SQL
2 votes355 views1 answer
Postgresql left join distinct on
SQL
0 vote328 views1 answer
Mysql max number not returning correct value
SQL