To update a particular row using cursor.

shalini bhat · New User Joined: 26 Feb 2007 Posts: 4 Location: India

Hi,

I am using a cursor and say I am fetching 5 rows from the table.
I want to update the 3rd row .
How do I acheive this ? I can check the value and then update saying current of. But is there any other way ?

-Shalini

dineshness · Posted: Tue Mar 20, 2007 12:27 am

If you are sure that you are always going to update the third row of the result set, then may be you can code a typical select statement without the use of cursor to get the values from database and update it directly with an update statement.

But by using the cursor, You have to fetch the row that you want to update and use the "Where current of" option.

Dinesh.