Re: listing all tables in a database??

Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de> wrote: > hawk <hawk_at_hotmail.com> wrote:
>> Hi all,
 

>> Is there a way to list all the tables in a database. I use Oracle 7 for
>> UNIX.
>> Thanks

> with  

> select * from all_tables;  

> you can see all within your scope  

> Johannes

   excuse me, it must be

     select * from all_catalog;

   Johannes Received on Fri Dec 29 2000 - 06:55:40 CST