FreeLists / oracle-l / RE: Command to view tables inside a database

["Powell, Mark D" <mark.powell@xxxxxxx>]

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