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

0 vote263 views2 answers
How to save result of sqlite query in a table
SQL
5 votes296 views1 answer
Sql table columns
SQL
5 votes286 views5 answers
Find max number in sql
SQL
0 vote299 views1 answer
Sql ssrs
SQL
0 vote267 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote264 views1 answer
Postgres full text search example
SQL
-1 vote293 views1 answer
Auto increment psql not primary key
SQL
1 vote265 views1 answer
Oracle create program if no exists
SQL
0 vote333 views1 answer
Mysl like insert a variable
SQL
-1 vote268 views3 answers
Psql get last rows
SQL