Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Question about MS SQL to Oracle conversion - Temp Tables in Procs

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

From: Preston Crawford <prestoncREMOVESPAMBLOCK_at_crawfordsolutions.com>
Date: Fri, 19 Jan 2001 17:34:36 GMT
Message-ID: <MU_96.432$w84.143813@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 - 11:34:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US