Re: [Q] Cursor navigation ?

David Russell wrote:
>
> Currently Oracle does not suupport the ability to use scrollable cursors,
> they MAY exist in a future release (8.1 ?).
>
> Regards
> David Russell
>
> bagnonm_at_I_should_put_my_domain_in_etc_NNTP_INEWS_DOMAIN wrote in article
> <65gj2e$o1p_at_polaris.inta.es>...
> > I know how to retrieve the rows from a SELECT statement using
> > FETCH, which navigates secuentially through the query result,
> > but only going forward.
> >
> > Is there any way to fetch backwards, as other sql's do ?
> >
> >

Hi The Problem with cursors is its always TOP -DOWN approach. I had this problem in one of my projects. The solution for this is PL/SQL TABLES (Arrays).

Hope This Helps
AMARENDRA

-- 
    AMARENDRA B NETTEM
    Certified Oracle DBA
    WHITTMAN-HART INC., CHICAGO
    Homepage : http://www.iit.edu/~nettama
    E-mail : anettem_at_whittman-hart.com
             nettama_at_charlie.cns.iit.edu