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

7 votes112 views2 answers
Create index mysql
SQL
0 vote116 views1 answer
Mysql timediff
SQL
0 vote134 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote78 views2 answers
Avg() sql
SQL
7 votes120 views1 answer
Safe update mysql
SQL
0 vote119 views2 answers
Create sequence if not exists postgres
SQL
9 votes112 views3 answers
Sequence postgresql
SQL
0 vote75 views1 answer
Sql select rows with simlar names
SQL
0 vote123 views1 answer
How to use lower case in mysql
SQL
0 vote142 views1 answer
Hour differeence in mysql
SQL