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 ?
Joined: 25 Dec 2006 Posts: 63 Location: Perambalur
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.