View previous topic :: View next topic
|
Author |
Message |
swati
New User
Joined: 14 Sep 2005 Posts: 7
|
|
|
|
default cursor is readable or updateble? |
|
Back to top |
|
|
krishnaboya
New User
Joined: 17 Nov 2005 Posts: 3
|
|
|
|
We can't say Cursor is by default Read only or updatable. It is depends on how do you define the cursor ....
Read only cursors are ...
1) If you define the cursor with for read only or for fetch only.
2) If you define the cursor with view which is read only.
3) If you define the cursor with UNION or Group By or Having or any User defined functions or Table functions
4) If you define the cursor with where clause
Updatable Cursors are ...
1) If you define a cursor with FOR UPDATE OF clause |
|
Back to top |
|
|
swati
New User
Joined: 14 Sep 2005 Posts: 7
|
|
|
|
Thanks for your reply |
|
Back to top |
|
|
|