Re: for loop in PL/SQL

If you count from 1 to 5, there is the way to know how to get the next value:
just to add 1. But how would Oracle know what follows the string "popo"?
If you meant processing like 'A', 'B', 'C', use 65..101 and chr(). If you meant
just any lines, put them into PLSQL table and process as you please.

Karen Abgarian.

Nandakumar wrote:

> Is there a way in PL/SQL to loop thru' a varchar2 list.
>
> Currently, the following snippet of code
>
> for count 1..5
> loop
> end loop; is valid in PL/SQL; count being an integer.
>
> i want to do similar thing with a list of varchar2 fields like
>
> for value in 'A' 'B' 'C'
> loop
> end loop;
>
> how can i do this? Any suggestions???
>
> thanks
> Nanda
>
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 16:04:29 CDT