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 vote97 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote101 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote95 views1 answer
Vbscript connect mssql
SQL
1 vote94 views1 answer
Copy postgres table from one schema into another
SQL
0 vote113 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote99 views1 answer
Restart identity postgresql
SQL
0 vote110 views2 answers
Replace null with 0 in sql
SQL
1 vote100 views2 answers
Regex starts with
SQL
0 vote110 views2 answers
How to generate a unique random number in mysql
SQL
14 votes108 views4 answers
Sql compiler
SQL