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

5 votes102 views3 answers
Sql max value in column
SQL
-1 vote109 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote133 views1 answer
Count of tables in database mysql
SQL
7 votes118 views1 answer
Grant schema permissions postgres
SQL
0 vote123 views1 answer
SQL SERVER xquery count child nodes
SQL
3 votes95 views2 answers
How to start mysql in terminal
SQL
0 vote109 views1 answer
Psql no such file or directory
SQL
19 votes110 views6 answers
Sql drop table if exists
SQL
0 vote116 views1 answer
A network or instance-specific error sql server
SQL
0 vote101 views1 answer
Select all tables linked server sql
SQL