Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: cjlambert@llnl.gov (christopher lambert)
Newsgroups: comp.databases.oracle.misc
Subject: iterating through all_tables
Date: 5 May 2003 15:57:18 -0700
Organization: http://groups.google.com/
Lines: 9
Message-ID: <1932d1c8.0305051457.3efca49@posting.google.com>
NNTP-Posting-Host: 128.115.53.183
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1052175438 31177 127.0.0.1 (5 May 2003 22:57:18 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 5 May 2003 22:57:18 GMT
Xref: core-easynews comp.databases.oracle.misc:97348
X-Received-Date: Mon, 05 May 2003 15:56:48 MST (news.easynews.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