Subject: RE: Command to view tables inside a database 2007-11-01 - By Powell, Mark D
Back
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Asif Momen
Sent: Thursday, November 01, 2007 5:10 AM
To: shweyeesyt@(protected); oracle-l@(protected)
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@(protected)> 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=764201413-01112007>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=764201413-01112007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left>
<P class=MsoBodyTextIndent2
style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: 0in"><SPAN
style="FONT-STYLE: normal">How do I find information about a database object:
table, index, constraint, view, etc… in Oracle ?<SPAN
style="mso-spacerun: yes"> </SPAN></SPAN><A
href="http://www.jlcomp.demon.co.uk/faq/object_info.html"><EM>http://www.jlcomp
.demon.co.uk/faq/object_info.html</EM></A><EM>
</EM></P></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Arial size=2>-- Mark D Powell --</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2>Phone (313) 592-5148</FONT></SPAN>
</P>
<DIV> </DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Asif
Momen<BR><B>Sent:</B> Thursday, November 01, 2007 5:10 AM<BR><B>To:</B>
shweyeesyt@(protected); oracle-l@(protected)<BR><B>Subject:</B> Re: Command
to
view tables inside a database<BR></FONT><BR></DIV>
<DIV></DIV><BR>Hi,<BR><BR>Querying *_TABLES (replace * with ALL, DBA, or USER
)
view will list you all tables. <BR><BR>Oracle reference manual lists all the
views with description and you may find it very help.
<BR><BR>http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc
.htm<BR><BR><BR>Regards<BR><BR><BR><B><I>Shwe
Yee Than <shweyeesyt@(protected)></I></B> wrote:
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px
solid">Hi,<BR><BR>I'm
new to Oracle Database. I'm now using <SPAN class=parahead1>Oracle
Database 10<I>g</I> Release 2. Can anyone tell me the command to view
all the tables inside a specific oracle database?<BR><BR>Really appreciate
for the helping hands.<BR><BR>Regards,<BR>Shwe</SPAN>
<DIV>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<BR>Do You
Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </DIV></BLOCKQUOTE><BR>
<P>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<BR>Do You
Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </P></BLOCKQUOTE></BODY></HTML>
|
|
