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

2 votes165 views2 answers
How to add not null constraint in sql
SQL
5 votes147 views1 answer
Oracle ora-00054 causes
SQL
2 votes142 views1 answer
Convert series number to date in sql
SQL
0 vote110 views1 answer
Now() -1 mysql
SQL
0 vote162 views1 answer
Look at running processes redshift
SQL
0 vote153 views2 answers
Script all indexes in a database
SQL
0 vote168 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote157 views1 answer
Oracle exchange subpartition
SQL
6 votes155 views1 answer
Postgres get size of database
SQL
28 votes149 views6 answers
Sql update
SQL