Re: jumping to records

A D Hager wrote:
>
> Is it possible to select all records from a table but to jump to a
> particular one?
> for example suppose I want to retrieve all records from a table but I
> want to start somewhere in the middle.
> If I execute
> select * from employees where name='aaron'
> I will only get one record.
> If I execute
> select * from employees;
> I will only get all the records and will have to retrieve many records
> before finding the one I am looking for.
>
> Thanks a lot,
>
> Aaron

Presuming Forms, you can

execute_query(all_records)
go_record(n)

HTH

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

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