-
Junior Member
Re: For update clause
Hi,
For Update clause is always used in a cursor(or a simple SELECT statement).
The advantage of locking a set of rows fetched by cursor(or a select statement) over an exclusive lock on an update or delete transaction is,
the set of SELECTED rows can be locked before u can modify so that denying the modification of the same set of rows by other user.
Thanks,
Savitha
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules