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 vote164 views1 answer
Add SuperUser MySQL
SQL
0 vote150 views2 answers
Sqlite unique
SQL
1 vote155 views1 answer
Update mysql centos
SQL
0 vote147 views1 answer
Get number of rows in every table mysql
SQL
6 votes192 views2 answers
What is non relational database
SQL
0 vote155 views1 answer
Sql offfset
SQL
1 vote143 views1 answer
Nested if in mysql
SQL
-1 vote163 views1 answer
Default username and password for oracle 11g
SQL
4 votes209 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
22 votes213 views4 answers
Mysql format date
SQL