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 vote270 views2 answers
Impala rename column name
SQL
2 votes253 views1 answer
Postgresql update sequence next value
SQL
0 vote222 views1 answer
Resulting Query
SQL
32 votes258 views6 answers
Insert select
SQL
1 vote263 views1 answer
Mysql login console
SQL
0 vote264 views2 answers
Mysql update two tables at once
SQL
0 vote232 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote228 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote221 views1 answer
Mysql group rows with same value
SQL
4 votes227 views2 answers
Tables in sql
SQL