I wanted to know how to move backwards while scanning recods in a cursor when meeting with a perticular condition.For example, if after scanning 50th record of a recorset, I have to make some updates in 25th record. How to go about it?

Showing Answers 1 - 4 of 4 Answers


  • Feb 18th, 2007

Cursors are forward only, as such you can't go back.

  Was this answer useful?  Yes

Shiril Kumar Dubey

  • Mar 21st, 2007

IT can only be possible through the collections.... go through the chapater NO 12 PL/SQL O'reiilly Publications.

  Was this answer useful?  Yes

Habib Ali

  • May 10th, 2016

Cursor is bi-directional.... You have to start either from FIRST or LAST record. You can however access nth record directly too, if not required by any logic

  Was this answer useful?  Yes


  • Jul 14th, 2016

In cursor we dont have the facility of moving directly to a nth record.
We have to loop through the cursor to reach the nth record but even though after reaching you cant move backward.
Its good to use PL/SQL tables for this kind of situation

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions