CodeSnip: Practical Use of "for update of" in Oracle Cursor
page 5 of 5
by Deepankar Sarangi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 25279/ 39

Conclusion

This code snip demonstrates the practical use of "for update of" and "current of" facilities in oracle. "For update of" puts a lock on the column mentioned in the select statement. As a result, the column is locked during the updating of that column.

During the coupon merging, the coupons of the current of clauses hold that record to be updated which is being pointed by the cursor.


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 





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


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-15 6:18:49 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search