OraFAQ Forum: SQL & PL/SQL » Fetching backward from cursor?????Urgent

Home » SQL & PL/SQL » SQL & PL/SQL » Fetching backward from cursor?????Urgent

Mon, 25 March 2002 20:12

Neeti Goyal
Messages: 1
Registered: March 2002

Junior Member

In sql we can use fetch prior for fetching the previous records from cursor. What I can use in oracle if I want to retrieve prior record.

Tue, 26 March 2002 13:46

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

In Oracle 8i and earlier, you can only move forward through a cursor. I believe that 9i adds support for bi-directional cursors.

Previous Topic:	Order of INDEXES
Next Topic:	Function

Goto Forum:

]

Current Time: Tue Apr 23 07:32:00 CDT 2024