Re: Question about MS SQL to Oracle conversion - Temp Tables in Procs

Unlike SQLServer you can just issue your query and get whatever rows you want. Or you could track the rowids. 8i has temp tables that last for duration of a transaction or a login.
Jim

"Preston Crawford" <prestoncREMOVESPAMBLOCK_at_crawfordsolutions.com> wrote in message news:MU_96.432$w84.143813_at_dfiatx1-snr1.gtei.net...
> FWIW, the reason I wanted to do it this way is because if you drop a query
> result into a temp table with an auto-incrementing ID then you can simply
> page by going between a range of the auto-incrementing ID field instead of
> having to bring back the entire recordset and page through that with ADO.
 So
> it would be faster (assuming temp tables are pretty fast in Oracle) in
 that
> you wouldn't be bringing back tons of unnecessary data for just 20 records
> or whatever.
>
> Preston
>
>
Received on Fri Jan 19 2001 - 21:04:10 CST