Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Command to view tables inside a database

RE: Command to view tables inside a database

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 1 Nov 2007 09:17:03 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9018BCDC1@usahm208.amer.corp.eds.com>


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>  

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Asif Momen

	Sent: Thursday, November 01, 2007 5:10 AM
	To: shweyeesyt_at_yahoo.com; oracle-l_at_freelists.org
	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_at_yahoo.com> 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 


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 01 2007 - 08:17:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US