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

Home -> Community -> Usenet -> c.d.o.tools -> Re: sql select statement

Re: sql select statement

From: TurkBear <noone_at_nowhere.com>
Date: Thu, 12 Apr 2001 09:03:14 -0500
Message-ID: <sadbdt43viamqptpml7m6q6u5pvuj5sifu@4ax.com>

To be sure you get ALL tables and not just those you, as a user, would have access to and If you have DBA authority use

select table_name from sys.dba_tables;

root <root_at_att.net> wrote:

>Thank you.
>
>bryan munday wrote:
>
>> >===== Original Message From mousepoet <mousepoet_at_att.net> =====
>> >What command would I use to list the tables in a database?
>>
>> This has been asked a lot on the group.
>>
>> select table_name from all_tables
>>
>> Bryan
>>
>> ------------------------------------------------------------
>> Get your FREE web-based e-mail and newsgroup access at:
>> http://MailAndNews.com
>>
>> Create a new mailbox, or access your existing IMAP4 or
>> POP3 mailbox from anywhere with just a web browser.
>> ------------------------------------------------------------

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Apr 12 2001 - 09:03:14 CDT

Original text of this message

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