iterating through all_tables

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