Re: listing all tables in a database??

From: <steveee_ca_at_my-deja.com>
Date: Fri, 29 Dec 2000 12:06:51 GMT
Message-ID: <92huoq$6bf$1@nnrp1.deja.com>

In article <92ho0b$605$1_at_bugstomper.ihug.com.au>, "hawk" <hawk_at_hotmail.com> wrote:
> For that I'll need to know the name of the table. That's the reason
why I
> am looking for such a command as I don't know ALL the tables in the
> database. Basically, what I am looking for is an equivalent of 'ls'
in UNIX
> or 'dir' in DOS..
>

Hi,

No..you don't substitute a table name where the poster wrote "table_name"..

You type exactly what he says like this:

SELECT TABLE_NAME FROM DBA_TABLES; Hope this helps clear it up.

Steve

> Michael Puente <corky_at_skyinet.net> wrote in message
> news:AeZ26.6$vQ1.21029_at_news1.onlynews.com...
> |
> |
> | be a user with access to dba_tables
> | select table_name from dba_tables;
> |
> |
> | "hawk" <hawk_at_hotmail.com> wrote in message
> | news:92hn0m$5de$1_at_bugstomper.ihug.com.au...
> | > Hi all,
> | >
> | > Is there a way to list all the tables in a database. I use Oracle
7 for
> | > UNIX.
> | > Thanks
> | >
> | >
> |
> |
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 29 2000 - 06:06:51 CST