CodeSnip: How to Implement Merge Facility Using Local Variables?
page 4 of 4
by Deepankar Sarangi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20394/ 28

Conclusion

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.


View Entire Article

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 9:25:20 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search