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 vote118 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
5 votes693 views1 answer
Oracle ora-00054 find
SQL
2 votes131 views1 answer
Sql string starts with
SQL
1 vote121 views1 answer
Oracle turn off constraint
SQL
0 vote116 views1 answer
Fill up postgres db
SQL
6 votes118 views1 answer
Update left join mysql
SQL
0 vote114 views1 answer
Tsql default value when no value returned by query
SQL
0 vote110 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
5 votes66 views1 answer
Copy table from one database to another mysql
SQL
7 votes136 views4 answers
Mysql delete older duplicates
SQL