Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Ways to list available tables?
TNKS wrote:
> ...
> Does anybody know of a way a simple user like myself can query the database
> for all the tables I can see. . . otherwise I have to deal with a person
> (our DBA), who historically beats around the bush, and stalls progress.
>
> ...
Try:
SELECT * FROM ALL_TABLES; If you just want to see tables you _own_, it was SELECT * FROM USER_TABLES; Hope it helps
Arnold Schommer Received on Thu Dec 10 1998 - 00:00:00 CST