Home » SQL & PL/SQL » SQL & PL/SQL » Last Record In Cursor
Last Record In Cursor [message #35950] Thu, 25 October 2001 08:24 Go to next message
KAW
Messages: 8
Registered: February 2001
Junior Member
Is there a way to start a cursor at the last row and then navigate back up the cursor using previous or next type commands?

----------------------------------------------------------------------
Re: Last Record In Cursor [message #35954 is a reply to message #35950] Thu, 25 October 2001 08:59 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
I don't think so. You could read the cursor into a PL/SQL table and use that functionality. Or, if you only want to get the records in reverse order, you might consider changing the sort criteria in the cursor from ASC to DESC or vice versa.

----------------------------------------------------------------------
Previous Topic: can pl/sql be used for reporting purpose?
Next Topic: Having a problem with foreign key when creating table
Goto Forum:
  


Current Time: Fri Feb 21 01:09:12 CST 2020