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 vote195 views1 answer
Sqlite referential integrity
SQL
0 vote204 views1 answer
How to delete python anywhere mysql database
SQL
0 vote194 views1 answer
Alter table myisam to innodb
SQL
8 votes186 views1 answer
Unique vs primary key
SQL
0 vote200 views3 answers
Postgres trim string
SQL
1 vote204 views1 answer
Quit mysql
SQL
0 vote180 views5 answers
Sql table intermédiaire
SQL
0 vote203 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
-1 vote256 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote195 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL