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 vote167 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote200 views1 answer
How to check rollback status in oracle
SQL
24 votes178 views6 answers
Replace mysql
SQL
1 vote181 views2 answers
Drop table with constraints
SQL
4 votes161 views6 answers
Second max salary in sql
SQL
0 vote156 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote155 views1 answer
How to get inserted id in sql server
SQL
5 votes160 views3 answers
Oracle list columns in schema
SQL
1 vote173 views1 answer
Find difference in dates sql
SQL
1 vote200 views1 answer
How to check all scheduled jobs in oracle
SQL