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>

Mark D Powell -- Phone (313) 592-5148

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