Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: listing all tables in a database??
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
![]() |
![]() |