How Control Number of Records to Fetch?

[Jun]

Hi,

I'm using Ado, Oracle Provider, VC++6
My program fetch the Oracle table and put
it in DataGrid for editing. It work fine
for the first few hundreds of records, but as
number of record records increases -- the time
to initialize the recordset ( maybe we can
say it loading of records to client side ).

The problem is that I want to control this Recordset
that it must read only the first 100, then next 100, etc.
(through buttons accessible by the user.)

Or is it possible in Oracle SQL to control the number of
records to return?

Thanks.