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 vote323 views1 answer
Change schema of all tables postgres
SQL
0 vote342 views1 answer
Create boolean column in MySQL with false as default value?
SQL
4 votes338 views1 answer
Oracle error line
SQL
1 vote327 views1 answer
Sql select contem uma palavra
SQL
21 votes322 views3 answers
Sql average
SQL
4 votes316 views1 answer
Postgresql change default value
SQL
1 vote347 views1 answer
Postgresql append array
SQL
0 vote354 views1 answer
Tinydb add table
SQL
0 vote350 views3 answers
Remove folders from remote git
SQL
0 vote340 views1 answer
Sql reverse order of results
SQL