Home » SQL & PL/SQL » SQL & PL/SQL » List of Tables in Database
List of Tables in Database [message #19642] Tue, 02 April 2002 08:00 Go to next message
yolanda rahming
Messages: 2
Registered: April 2002
Junior Member
I'm new at this. Could someone please give me the SQL Command to retrieve a list of all tables in an Oracle Database. Thanks.
Re: List of Tables in Database [message #19651 is a reply to message #19642] Tue, 02 April 2002 21:54 Go to previous message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

you got the "all_tables" view or the "user_tables" view. Alternatively you might use the "all_objects" view or the "user_objects" view with the where-clause = "where object_type = 'TABLE'".
See more views at :
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/general.htm#10743

Success,

epe
Previous Topic: Re: Interaction between VB and Oracle Procedure using Cursor as return type
Next Topic: Re: connecting oracle 8i with d2k
Goto Forum:
  


Current Time: Fri Mar 29 08:54:14 CDT 2024