Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL statement to get all tables in the database

Re: SQL statement to get all tables in the database

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 14 Nov 2004 21:36:02 -0800
Message-ID: <1100496883.462711@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US