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 vote196 views1 answer
Normalization in database 2nd normal form
SQL
0 vote239 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote217 views1 answer
How convert into in in sql query
SQL
1 vote200 views1 answer
Oracle grant on all tables in schema
SQL
15 votes233 views4 answers
Sql update from select
SQL
0 vote201 views1 answer
Sql column contains special character
SQL
0 vote191 views1 answer
Exec procedure oracle
SQL
0 vote190 views1 answer
Mysql Install Ubuntu with native password
SQL
18 votes231 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote223 views1 answer
Add sequence postgres
SQL