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 vote405 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote367 views1 answer
Copy postgres table from one schema into another
SQL
0 vote345 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote359 views1 answer
Login failed for login due to trigger execution
SQL
0 vote357 views1 answer
Truncate a table then insert data
SQL
6 votes394 views3 answers
Mysql remove user privileges
SQL
0 vote343 views1 answer
Create table if not exist with exceptions
SQL
0 vote382 views1 answer
Groupby sort sql hive
SQL
4 votes373 views6 answers
Sql select statement
SQL
-1 vote438 views1 answer
How to Activate the database
SQL