Upmerge

What is the benifit of using 'upmerge' command introduced in oracle 9i & how it works?
it is my open book bonus question in University i need it's expert answer as soon as possible.
Fahad_HafeezAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
morphmanConnect With a Mentor Commented:
You mean the MERGE command, or commonly called the "upsert". It is essentially 2 commands in 1, commonly used in ETL transformations. Basically the common operation is

"I want to update existing records, and create new records where a record doesnt already exist".

The merge command providess this functionality in 1 command , MERGE. In 8i SQL you would have to perform 2 statements. An UPDATE followed by an INSERT. This requires 2 table scans as opposed tot he MERGE commands single scan.

Hope this helps,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.