Re: Cursor Manipulation

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/31
Message-ID: <39857FF4.4689@yahoo.com>#1/1

Jack Tong wrote:
>
> Hi all,
>
> Got a question:
>
> How to move cursor to point to next or prev record, in PL/SQL? Or it cannot
> be done at all?

You fetch the next record - thus you can only move "top to bottom" through the cursor rows...You could store them in a pl/sql table table as you go to simulate "fetch previous"

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Jul 31 2000 - 00:00:00 CDT