The alternate solution to the use of merge may be to declare
any column in the destination table as the primary key. Then start inserting the
record into the table for fresh ones and use the "dup val on index"
error returned by Oracle to update the previously present records. But in case
we cannot declare any the primary key for business point of view, the idea will
not work. Therefore, the merge method looks obviously good and efficient in all
circumstances.