Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL statement to get all tables in the database
Matt wrote:
> In oracle, any SQL statements to get all tables in the database?
> I am using SQL* PLUS, and I want to see what are all tables in
> the database.
>
> Please advise. Thanks!!
What Bricklen said about the docs.
But also go to http://www.psoug.org
click on Morgan's Library
click on tables
All of the major table related data dictionary views are listed.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sun Nov 14 2004 - 23:36:02 CST