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

Home -> Community -> Usenet -> comp.databases.theory -> Cursor vrs Temp Tables

Cursor vrs Temp Tables

From: runstein <runstein_at_biotronik.com>
Date: Thu, 21 Mar 2002 08:04:41 -0800
Message-ID: <u9k02n4r40jbc1@corp.supernews.com> 





I know of two techniques for iterating through a resultset.  One being a
cursor, the other is creating a temp table and looping through the records.



Does anyone know which technique is more efficient?  Are there situations
where one is clearly better (or worse) than the other?



Thanks in advance
Received on Thu Mar 21 2002 - 10:04:41 CST












Original text of this message













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