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

7 votes212 views1 answer
Sql pagination oracle
SQL
0 vote215 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote186 views1 answer
Primary key multiple colums
SQL
0 vote181 views1 answer
Select from column mysql
SQL
0 vote179 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote224 views1 answer
000webhost database values insert
SQL
2 votes193 views1 answer
Postgresql create schema in specific database
SQL
0 vote229 views1 answer
Postgres - Login and connect as default user
SQL
0 vote231 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote196 views1 answer
Sql python hwo to pass a list in paramerter
SQL