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

6 votes310 views3 answers
Mysql change auto_increment start value
SQL
0 vote360 views1 answer
Sql alternative to max statement
SQL
9 votes290 views2 answers
Oracle all tables in schema
SQL
0 vote321 views1 answer
Php mysqli install
SQL
6 votes318 views2 answers
Non relational database
SQL
0 vote307 views1 answer
Show table details postgresql
SQL
1 vote311 views1 answer
Sql into vs insert into
SQL
0 vote304 views1 answer
Increase speed of like queries postgres
SQL
22 votes298 views4 answers
Show list of users in mysql
SQL
0 vote310 views1 answer
Create dump file mysql workbench
SQL