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

1 vote375 views1 answer
Round function in sql oracle
SQL
-1 vote366 views2 answers
Postgresql user permissions to database
SQL
-1 vote335 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
5 votes378 views2 answers
Sql conn
SQL
0 vote342 views1 answer
Mariadb mysql root access denied
SQL
0 vote363 views2 answers
Postgres show current role
SQL
-2 votes343 views3 answers
Oracle tablespace usage
SQL
1 vote344 views2 answers
How to check username in mysql command line
SQL
0 vote343 views1 answer
Postgres 11 add primary key
SQL
0 vote371 views1 answer
How to import pymysql through jupyter notebook for windows
SQL