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

14 votes182 views2 answers
Oracle limit rows
SQL
0 vote180 views1 answer
How to check which sp is running in sql server
SQL
5 votes175 views1 answer
How to get all dates in a month in oracle
SQL
0 vote189 views1 answer
PGSQL dynamic table name
SQL
0 vote188 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote185 views1 answer
Oracle simple quote
SQL
5 votes175 views1 answer
Minecraft java port number
SQL
6 votes190 views1 answer
SQL insert all columns
SQL
8 votes174 views3 answers
Alter table auto_increment
SQL
0 vote176 views2 answers
Update all linkedserver tables with openquery on db
SQL