How to Run this PLSQL Block.

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. Received on Mon Nov 27 2006 - 07:23:37 CST