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

2 votes336 views1 answer
Columns Present in a table
SQL
0 vote347 views1 answer
Create bdd mysql
SQL
0 vote327 views1 answer
PSQL qith variables
SQL
49 votes389 views6 answers
Alter table add column
SQL
1 vote343 views1 answer
Moodle query item quiz
SQL
0 vote396 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote327 views1 answer
Postgre admin slow
SQL
0 vote339 views1 answer
Postgresql not in alternative
SQL
0 vote389 views1 answer
Postgres docs /copy metacomand
SQL
12 votes397 views4 answers
How to drop all tables in postgresql
SQL