Oracle insert or update

-- 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

1 vote345 views1 answer
Postgres cast as currency format
SQL
0 vote297 views1 answer
Sql runnignsum
SQL
0 vote325 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
-1 vote299 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
8 votes334 views2 answers
Grant all privileges database postgres to user
SQL
1 vote338 views1 answer
Error code 1292 mysql workbench
SQL
2 votes334 views1 answer
How to delete view in sql
SQL
2 votes359 views1 answer
How to select from mssql
SQL
0 vote329 views1 answer
Restart sql server command line linux
SQL
1 vote325 views3 answers
Postgresql crete view
SQL