Re: how to view all tables?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 10 Apr 2005 23:07:43 +0200
Message-ID: <ra5j51l22bq8s5rf10v3ujsqbfmb6s6dn6@4ax.com>

On Mon, 11 Apr 2005 03:04:40 +0930, "Ian" <not_at_available.com.au> wrote:

>Hi,
>I have just installed Oracle 10 on Solaris and would like to practice some
>SQL
>I selected the examples & schema examples to be installed.
>Could someone please help me how to find the examples schema, or the command
>to view all the table names?
>I need to know what to querry. eg select * from ???
>thanking you in advance
>

Apart from the response by IANAL_VIST

select * from dict
will provide you all the names of the dictionary vies and
select * from dict_columns
their respective columns.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Apr 10 2005 - 16:07:43 CDT