for loop in PL/SQL

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 Thu Aug 26 1999 - 18:50:39 CDT