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 vote349 views1 answer
Sqlite trim
SQL
0 vote379 views1 answer
Query only first letter string
SQL
0 vote309 views1 answer
SqlFunction does not exist
SQL
3 votes332 views2 answers
Postgres inner join vs join
SQL
11 votes303 views2 answers
Import sql file laravel cmd
SQL
17 votes326 views4 answers
Sort by mysql
SQL
2 votes320 views1 answer
Sqlite insert if not exists
SQL
6 votes359 views3 answers
Psql show columns of table
SQL
1 vote318 views2 answers
How to add amount between date in sql
SQL
0 vote331 views4 answers
First max salary in sql
SQL