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

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Cursor question..

PL/SQL Cursor question..

From: kb <kbesner_at_hfx.eastlink.ca.nospamm>
Date: Thu, 18 Dec 2003 02:38:56 -0400
Message-ID: <SSbEb.148741$PD3.5858379@nnrp1.uunet.ca> 





Hi guys/gals.


If I have a piece of code that declares a cursor, and then a piece of code
that calls it in a For Loop statement,



CURSOR xx


Select....etc...


xxx




FOR <whatever> in <CURSOR> LOOP


xx


xx


xx


ENDLOOP


My question is, does the Cursor get run once, returning a list that the FOR
LOOP code then loops through, or is the cursor actually called over and over
again by the FOR statement?


Sorry for the rookie question!!!  Thanks!
Received on Thu Dec 18 2003 - 00:38:56 CST












Original text of this message













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