Re: iterating through all_tables

> Not sure why one would want to, but look at NDS(native dynamic sql or
> dbms_sql package)
> Jim

just fyi, all of our tables have a common field - "instance". I want to search through all our tables to select the tables that have a particular instance value in them.

> "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 Tue May 06 2003 - 12:47:02 CDT