Retrieving only a part of a query - help!

Hello,

unlike MS Access, where I can specify a SQL Statement to retrieve only x records or x% of a query result, I desperately search for a similar SELECT statement in an Oracle (8i) database.

The task: I have to connect to the Oracle database via ODBC/ADO from an ASP script, which should distribute the query result on more than one page. Even the OLE DB provider doesn't support the AbsolutePosition or AbsolutePage (and similar) properties with Oracle.

I thought this would be a common task but I didn't find any infos about it in the Usenet or the W3.

Any help will be appreciated. Please reply also per mail. TIA Ciao,

        Ralf "Arby" Brostedt

-- 
no sig today