Oracle

How can i view tables in the databse

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2008

Posts: 11

Reputation: topsege2007 is an unknown quantity at this point

Solved Threads: 0

topsege2007 topsege2007 is offline

Offline

Newbie Poster

How can i view tables in the databse

Aug 14th, 2008

Like the DESCRIBE statement used to view columns in a given table, What SQL statement can i use to view the tables in a database. (Oracle 10g)

•

Join Date: Nov 2004

Posts: 6,143

Reputation: jwenting is just really nice

Solved Threads: 213

jwenting

Offline

duckman

Re: How can i view tables in the databse

Aug 16th, 2008

The following will give you information on all tables:

Help with Code Tags

Oracle Syntax (Toggle Plain Text)

SELECT * FROM sys.ALL_ALL_TABLES;

Many of those of course will be system tables, not application tables.
And depending on the user you are, you may not be able to execute the query (you may not have the privileges) and may not be able to access all tables you get returned.

Last edited by jwenting; Aug 16th, 2008 at 11:10 am.

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.

•

Join Date: Aug 2008

Posts: 11

Reputation: topsege2007 is an unknown quantity at this point

Solved Threads: 0

topsege2007 topsege2007 is offline

Offline

Newbie Poster

Re: How can i view tables in the databse

Aug 27th, 2008

type this command
SELECT * FROM ALL_TABLES . this will enable to view all the tables that yuou have created and the one you granted provilege to view.

Last edited by peter_budo; Aug 29th, 2008 at 7:34 pm. Reason: Keep It Organized - please use [code] tags