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

0 vote337 views1 answer
Group by two columns postgres
SQL
0 vote322 views1 answer
Oracle db get table sizes
SQL
0 vote321 views1 answer
This week mysql
SQL
1 vote317 views2 answers
Sql multiline comment
SQL
0 vote334 views1 answer
Find usage of table in sql server
SQL
103 votes540 views1 answer
Like sql
SQL
0 vote301 views2 answers
Avg() sql
SQL
0 vote330 views1 answer
Convert rows to columns in sql server
SQL
5 votes315 views1 answer
Mysql get last day of month
SQL
4 votes336 views1 answer
For loop postgresql
SQL