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 vote217 views1 answer
Sql server convert to guid
SQL
0 vote218 views1 answer
Alter table engine mysql
SQL
0 vote165 views1 answer
Store query result in variable sql
SQL
1 vote210 views1 answer
Postgresql float 2 decimal places
SQL
0 vote204 views1 answer
Two inner joins sql
SQL
1 vote197 views1 answer
Postgres format date in select
SQL
-1 vote192 views3 answers
Mysql get age from date
SQL
2 votes206 views1 answer
Get first n letter of department name in sql
SQL
0 vote208 views1 answer
Add sqlcmd to path linux
SQL
0 vote192 views1 answer
Postgres 11 add primary key
SQL