Re: PL/SQL Cursor question..

Hi,

the Cursor runs only one times when the CURSOR-Statement will be run. The FOR LOOP statement then went through the OPEN CURSOR and you can go from one record to the other.

Hope i could help you!!

(Sorry for my worse english)

Greetings Dirk

"kb" <kbesner_at_hfx.eastlink.ca.nospamm> schrieb:

>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 - 02:11:15 CST