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 vote126 views1 answer
Oracle select row max date
SQL
0 vote112 views3 answers
How to assign custom id in mysql
SQL
16 votes105 views2 answers
Mysql date between two dates
SQL
4 votes89 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote61 views1 answer
Mysql date + 1 day
SQL
0 vote110 views1 answer
Convert int to varchar sql
SQL
0 vote114 views2 answers
Suse stop MySQL
SQL
5 votes113 views1 answer
Oracle list days between two dates
SQL
5 votes103 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote115 views1 answer
Psql check if sql script is valid
SQL