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

Home -> Community -> Usenet -> c.d.o.server -> Re: Ways to list available tables?

Re: Ways to list available tables?

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: 1998/12/10
Message-ID: <366FF604.8D932617@fs-edv.de>#1/1

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

Original text of this message

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