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 vote189 views1 answer
Learn sqlite dart
SQL
1 vote225 views1 answer
Replace all numbers in mysql
SQL
5 votes254 views4 answers
Rollback to in sql
SQL
2 votes202 views1 answer
Convert series number to date in sql
SQL
0 vote203 views1 answer
Test the postgresql db connection
SQL
8 votes229 views1 answer
Mysql restore database
SQL
0 vote198 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote236 views1 answer
Install postgresql 12 on debian 10
SQL
-1 vote263 views3 answers
Error: mysql shutdown unexpectedly.
SQL
29 votes201 views5 answers
Mysql show table structure
SQL