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 vote167 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote162 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote235 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote187 views1 answer
Denied
SQL
1 vote321 views1 answer
Mysql data from file
SQL
0 vote164 views1 answer
Set column width in sqlplus
SQL
3 votes165 views1 answer
APEX elapsed time
SQL
0 vote186 views1 answer
Sql last 3 rows
SQL
7 votes172 views3 answers
Postgre describe table
SQL
0 vote137 views1 answer
Mysql insert with foreign key
SQL