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 vote259 views1 answer
Compare subqueries oracle
SQL
15 votes229 views2 answers
How to know the username of postgresql
SQL
8 votes234 views2 answers
Oracle auto increment primary key
SQL
22 votes238 views4 answers
Mysql date format
SQL
1 vote274 views1 answer
Sql server set variable if exists
SQL
1 vote198 views1 answer
Foreign key in oracle sql developer
SQL
1 vote240 views1 answer
Postgres install unaccent extension
SQL
0 vote238 views1 answer
Postgres declare variable
SQL
1 vote264 views1 answer
Sql row having max
SQL
1 vote280 views2 answers
Laravel jwt generate token
SQL