yousuf_at_gmail.com wrote:
> Hello guys,
>
> I am trying to right this plsql block that has nested loop. The place
> where I am stuck is that how do I get a substitute for this :
> << j_loop >> FOR j IN 40 .. 57 ( this is what I am doing and it would
> loop for all the numbers from 40 to 57)
>
> What I want to acheive is :
>
> << j_loop >> FOR j IN (40, 41, 45, 51,55, 57) -- here there is no
> specific pattern, its just a list of number that I want to loop for.
>
> Any suggestions.
What you are describing is not a loop. What is it you are actually
trying to accomplish? And in what version of Oracle?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Nov 27 2006 - 10:24:34 CST
