Re: SQL statement to get all tables in the database

From: Bricklen <Xbricklen_at_yahoo.comX>
Date: Mon, 15 Nov 2004 03:26:37 GMT
Message-ID: <NlVld.224157$%k.70165@pd7tw2no>

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!!

dba_tables

However. you'll be better served by using the docs at docs.oracle.com for these types of questions. Received on Sun Nov 14 2004 - 21:26:37 CST

This message: [ Message body ]
Next message: Jim Kennedy: "Re: Why the size of Oracle 10g database is much smaller than Oracle 9i?"
Previous message: Matt: "SQL statement to get all tables in the database"
In reply to: Matt: "SQL statement to get all tables in the database"
Next in thread: DA Morgan: "Re: SQL statement to get all tables in the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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