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

1 vote386 views1 answer
How to use db.execute
SQL
12 votes368 views3 answers
Install sqlite driver ubuntu
SQL
1 vote335 views1 answer
Find logged in users mysql
SQL
1 vote401 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
1 vote373 views1 answer
How to get previous year from sysdate in oracle
SQL
1 vote358 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote331 views1 answer
Deleted table in sql trigger
SQL
0 vote333 views1 answer
Oracle create package body
SQL
1 vote333 views1 answer
Oracle current sequence value
SQL
0 vote340 views1 answer
Mysql events not work
SQL