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 vote182 views1 answer
Incorrect datetime value sql table error 1292
SQL
7 votes180 views6 answers
Group_concat mysql
SQL
2 votes197 views1 answer
No data found oracle
SQL
0 vote157 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
5 votes246 views4 answers
Mysql on duplicate key update
SQL
2 votes200 views1 answer
Enum in SQL Server
SQL
4 votes193 views2 answers
Show all database inside postgresql
SQL
3 votes210 views2 answers
Mysql import gz
SQL
19 votes188 views2 answers
Mysql add column after another
SQL
0 vote196 views1 answer
Get primary key of table
SQL