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

5 votes272 views2 answers
Update all rows mysql
SQL
0 vote271 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
1 vote279 views1 answer
Lpad function in sql oracle
SQL
9 votes271 views1 answer
Identity insert on sql server
SQL
0 vote294 views1 answer
Mysql milliseconds
SQL
0 vote290 views2 answers
How to generate a unique random number in mysql
SQL
0 vote288 views1 answer
Set open file limit mac catalina mysql
SQL
92 votes514 views6 answers
Substring
SQL
1 vote311 views2 answers
Sql split string by space
SQL
0 vote290 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL