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 vote200 views1 answer
Oracle create index if not exists
SQL
0 vote281 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote214 views2 answers
Alter table add multiple columns mysql
SQL
1 vote203 views1 answer
How to test for sql injection
SQL
0 vote213 views1 answer
Group by two columns postgres
SQL
0 vote195 views2 answers
Auto increment column in mysql query results
SQL
0 vote239 views1 answer
How to define a non primary composite key in sql
SQL
19 votes233 views3 answers
Grant mysql
SQL
0 vote207 views1 answer
Sql period overlap
SQL
0 vote194 views1 answer
Psql no such file or directory
SQL