Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to select all tables of a database ?

Status
Not open for further replies.

mlotfi

Programmer
Oct 14, 2003
26
0
0
US
Hi,
I am a newbie to oracle and databases, could you please show me how to select all tables of a database ?
thank you
 
Do you mean see the names of the tables?

If so:

select table_name from [dba][user][all]_tables (perhaps set pause on first). Choose whichever from dba, user and all.

Is this what you require?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top