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

3 votes287 views2 answers
Mysql HAVING
SQL
0 vote281 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote290 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
3 votes286 views1 answer
Oracle apex warning message
SQL
0 vote328 views1 answer
Hashpass
SQL
2 votes288 views2 answers
Checking data type in sql server
SQL
1 vote251 views1 answer
Flask-sqlalchemy filter_by contains
SQL
1 vote288 views1 answer
How to drop function in sql
SQL
1 vote291 views1 answer
Oracle user last connection date
SQL
0 vote322 views1 answer
How to create notes in mysql
SQL