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

3 votes210 views1 answer
Sql several or
SQL
13 votes199 views3 answers
Sql online code
SQL
0 vote221 views1 answer
Sql select lowest value row
SQL
0 vote223 views1 answer
Mysql multiple count
SQL
15 votes227 views4 answers
Create table if not exists sql
SQL
2 votes229 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote217 views1 answer
How to create a table in sql stack overflow
SQL
11 votes228 views1 answer
Oracle insert into where
SQL
0 vote216 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
2 votes209 views1 answer
Pandas to sql index
SQL