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.