Oracle insert or update

-- 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 vote326 views1 answer
Create table with float datatype in sql server
SQL
17 votes316 views4 answers
Set mysql Password
SQL
0 vote306 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote340 views1 answer
Sql script get all stored procedures from database
SQL
0 vote358 views1 answer
Transaction and commit trong sql server
SQL
1 vote312 views2 answers
String to date postgres
SQL
0 vote340 views1 answer
Group by 15 minute interval sql server
SQL
0 vote313 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote341 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote328 views4 answers
How to connect form to database
SQL