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

-1 vote305 views4 answers
Sql view postgresql
SQL
5 votes283 views3 answers
Oracle first day of last year
SQL
0 vote270 views1 answer
Tsql default value when no value returned by query
SQL
13 votes293 views2 answers
Sqlite rename table
SQL
7 votes298 views1 answer
Oracle alter sequence restart start with
SQL
0 vote262 views1 answer
Django mysqlclient connection string
SQL
24 votes290 views6 answers
Replace mysql
SQL
0 vote278 views1 answer
Odd record sql query
SQL
0 vote285 views1 answer
Sql server select value large text
SQL
0 vote267 views1 answer
What is mysql_pconnect
SQL