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

1 vote124 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
1 vote128 views1 answer
Select from describe sql
SQL
0 vote122 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote137 views1 answer
Window function to forward fill
SQL
0 vote152 views1 answer
Mysql select random rows large table
SQL
33 votes129 views6 answers
Sql delete
SQL
10 votes149 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote141 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote131 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote118 views2 answers
Sql count number of rows after group by
SQL