Subject: Re: Command to view tables inside a database 2007-11-01 - By Asif Momen
Back
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 <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="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> 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
|
|