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
DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1100496883.462711_at_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.
select table_name from dba_tables where owner not in('SYS','SYSTEM'); Received on Mon Nov 15 2004 - 13:10:33 CST