Not sure why one would want to, but look at NDS(native dynamic sql or
dbms_sql package)
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"christopher lambert" <cjlambert_at_llnl.gov> wrote in message
news:1932d1c8.0305051457.3efca49_at_posting.google.com...
> I'd like to do the equivalent of a foreach loop with oracle. something
like this..
>
> foreach i (`select table_name from all_tables`)
> select * from $i;
> end
>
> does anyone know how to do this?
>
> - chris
Received on Mon May 05 2003 - 21:18:08 CDT
