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 vote261 views1 answer
The local psql command could not be located
SQL
0 vote287 views1 answer
C# get sql min date
SQL
0 vote291 views1 answer
Sql log file inof
SQL
0 vote293 views2 answers
List all constraints in postgres
SQL
3 votes292 views1 answer
Mysql insert on dupèlicate
SQL
0 vote274 views1 answer
How to output a different column name in mysql
SQL
7 votes299 views2 answers
Phpmyadmin change password
SQL
0 vote255 views1 answer
Time in sql server
SQL
0 vote340 views1 answer
How to check foreign key constraint in sql
SQL
-1 vote266 views1 answer
Ssms connect with connection string
SQL