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

0 vote247 views1 answer
How do you insert boolean to postgresql
SQL
0 vote198 views1 answer
Mysql min value row
SQL
1 vote176 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
2 votes250 views1 answer
Creating a view SQL
SQL
0 vote175 views2 answers
Mysql on update current_timestamp
SQL
0 vote181 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote185 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote193 views1 answer
Mysql get date diff in months
SQL
8 votes179 views3 answers
Connect python to mysql
SQL
1 vote288 views1 answer
Aqua Data studio postgresql ssl
SQL