Re: Cursor Manipulation

From: Jack Tong <jacktong_at_hkstar.com>
Date: 2000/08/01
Message-ID: <8m5fk6$cug3@imsp212.netvigator.com>#1/1

Thanks a lot.

In other words, a cursor cannot go back and fro, only forward.

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:39857FF4.4689_at_yahoo.com...
> 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 Tue Aug 01 2000 - 00:00:00 CDT