Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cursor looping - best practices?
On Jun 15, 12:30 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net>
wrote:
> The code you cite is, well, OLD code. I haven't written a loop like
> that in years, what with the FOR and WHILE constructs available:
>
> FOR myrec IN cursor LOOP
> .... processing here
> END LOOP;
>
> No manual checking for the end of the data, no manual exit strategy.
>
> For array processing a concise set of examples can be found at:
>
> http://www.psoug.org/reference/array_processing.html
...great, i will check that out. thanks
sm Received on Fri Jun 15 2007 - 14:43:39 CDT