View previous topic :: View next topic
|
Author |
Message |
chengodan Currently Banned New User
Joined: 18 Jun 2005 Posts: 1 Location: Chennai
|
|
|
|
Hi,
This is Cheng,
I wants to know the following usage,
1. For Update
2. Where current of
3. With Hold
I wants to know the Difference of these also. |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
All come in cursor declartion.
FOR UPDATE : It says which columns can be updated.
Where current OF : The latest row fetched using FETCH
WITH HOLD: says cursor not to be closed during COMMIT. It will still be closed if there are any ROLLBACKs. |
|
Back to top |
|
|
|