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: listing all tables in a database??

Re: listing all tables in a database??

From: hawk <hawk_at_hotmail.com>
Date: Fri, 29 Dec 2000 21:11:36 +1100
Message-ID: <92ho0b$605$1@bugstomper.ihug.com.au>

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..

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
| >
| >
|
|
Received on Fri Dec 29 2000 - 04:11:36 CST

Original text of this message

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