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

4 votes284 views2 answers
Postgresql reset sequence
SQL
0 vote350 views1 answer
ALV GRID events
SQL
1 vote288 views1 answer
Increasing font and zooming in mysql workbench
SQL
2 votes290 views1 answer
Drop sequence
SQL
2 votes308 views2 answers
Mysql count rows returned
SQL
18 votes291 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote244 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote316 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
1 vote296 views1 answer
Postgresql how to show table names
SQL
0 vote314 views1 answer
Mysql change default collation
SQL