Re: How can we list all the tables in a database?
From: Frank Greene <74200.427_at_CompuServe.COM>
Date: 1995/04/26
Message-ID: <3nk67q$3me$1_at_mhafa.production.compuserve.com>#1/1
Date: 1995/04/26
Message-ID: <3nk67q$3me$1_at_mhafa.production.compuserve.com>#1/1
better still, try the ALL_OBJECTS table.
Select object_name, object_type
from all_objects
where owner = <ownername>
order by object_type, object_name;
Received on Wed Apr 26 1995 - 00:00:00 CEST