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?

  • Interview Candidate
  • 12
  • 5630

Showing Answers 1 - 12 of 12 Answers

ram

  • 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

vinodkumar

  • 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