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 vote267 views1 answer
Store query result in variable sql
SQL
0 vote257 views1 answer
Mysql timeout 30 seconds
SQL
0 vote301 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote306 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote291 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote295 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
25 votes317 views4 answers
Sqlserver add column
SQL
0 vote300 views1 answer
How to get data from 2 database
SQL
1 vote308 views2 answers
Select into temp table
SQL
10 votes313 views2 answers
SQL rounding numbers
SQL