Home » SQL & PL/SQL » SQL & PL/SQL » list of tables
list of tables [message #20362] Thu, 16 May 2002 10:06 Go to next message
Rohit
Messages: 43
Registered: January 2002
Member
how to get list of all the tables in oracle database?
I am new to oracle. is there a system tables list i can scan. Help...

Report message to a moderator

Re: list of tables [message #20363 is a reply to message #20362] Thu, 16 May 2002 10:14 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
dba_tables (all table in database, requires privilege)
all_tables (all tables that you have access to)
user_tables (all tables in your schema)

Report message to a moderator

Previous Topic: sql query
Next Topic: V$ tables???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 05:50:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.