CodeSnip: How to Implement Merge Facility Using Local Variables?

(Deepankar Sarangi) This code snippet explains how to apply the merge utility available in Oracle. Merge proves to be a suitable option where both insert and update are needed simultaneously. It can insert records into a table while simultaneously updating the previous records. But the normal operat

Read More - Register for Free Membership