Oracle sql merge

-- 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

5 votes225 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote246 views1 answer
Sql use with to get value counts and percentages
SQL
23 votes218 views6 answers
Create table sql
SQL
3 votes232 views1 answer
Select count from table mysql
SQL
0 vote238 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote231 views1 answer
Query string starts with vowels
SQL
1 vote253 views2 answers
Truncate table sqlite
SQL
1 vote264 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
17 votes230 views3 answers
Postgresql version command
SQL
0 vote246 views1 answer
Mysql insert into select transaction c#
SQL