Re: Ways to list available tables?
From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: 1998/12/10
Message-ID: <366FF604.8D932617_at_fs-edv.de>#1/1
Date: 1998/12/10
Message-ID: <366FF604.8D932617_at_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 CET