RE: Command to view tables inside a database
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Nov 2007 09:17:03 -0400
Shwe, you are going to have more questions about where to look for basic
information about Oracle objects such as what columns are on a table,
what indexes exist on a table, what columns are in an index, and so on.
Here is a short article that introduces the basic rdbms dictionary views
that you use every day.
How do I find information about a database object: table, index,
constraint, view, etc... in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html
<http://www.jlcomp.demon.co.uk/faq/object_info.html>
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Asif Momen
Sent: Thursday, November 01, 2007 5:10 AM
To: shweyeesyt@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Command to view tables inside a database
Hi,
Querying *_TABLES (replace * with ALL, DBA, or USER) view will
list you all tables.
Oracle reference manual lists all the views with description and
you may find it very help.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm
Regards
Shwe Yee Than <shweyeesyt@xxxxxxxxx> wrote:
Hi,
I'm new to Oracle Database. I'm now using Oracle
Database 10g Release 2. Can anyone tell me the command to view all the
tables inside a specific oracle database?
Really appreciate for the helping hands.
Regards,
Shwe
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
