Re: Selecting all tables SQL

From: Martin Doherty <martin.doherty_at_oracle.nospam.com>
Date: Tue, 05 Nov 2002 16:24:38 -0800
Message-ID: <ImZx9.17$E23.45@news.oracle.com>

SELECT * FROM DICT will list for you the available data dictionary views.

SELECT * FROM ALL_TABLES to see all tables that your username has access to.

A table will appear in the listing regardless of whether it contains any rows or is empty.

hth
Martin

jimmy wrote:

>I am using Oracle SQL, and I cannot remember how to show all of the
>tables I have created In my database
>
>I have also forgotten the names of most of the tables
>
>also is it possible to show a table that has not had any information
>added to it when it was created
>
> Yours
> James mcgivern
>
>
Received on Tue Nov 05 2002 - 18:24:38 CST