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

0 vote342 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote352 views1 answer
Like sql for second letter of the family name
SQL
1 vote336 views5 answers
Sql 2nd highest salary
SQL
0 vote346 views1 answer
Mysql loop through databases and execute query
SQL
3 votes348 views2 answers
Install mysql powershell
SQL
4 votes338 views2 answers
Sql select except null
SQL
1 vote366 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote344 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote385 views1 answer
Drop view sql
SQL
0 vote334 views1 answer
Equi joins in oracle
SQL