Re: Newbie Question on tables

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Wed, 30 Dec 1998 18:43:59 +0100
Message-ID: <368A665E.1BBD8848@psi.de>

Hi Mike,

you will find these information in the data dictionary.

SELECT * FROM USER_TABLES lists all tables. There are a lot other important views in the dictionary. But if you prefer using a tool have a look at Hora 3. See http://www.keeptool.com for a free 30 days trial version of Hora 3.

regards Jan Dieckmann

Mike wrote:

> I signing up for classes as we speak!!
>
> I have Oracle 8 on Solaris. From Server Manager or SQL Plus what would
> be a command to list the tables. Or any other suggestions on how to
> accomplish this.
>
> For instance I connect as "Scott Tiger" to the demo database. How
> could I list the tables in this database? From the Oracle Documentation
> I know of one table "emp". How can I find out about the other tables?
>
> Forgive it this question is common knowlegde!!
>
> Thanks in advance
> mike
Received on Wed Dec 30 1998 - 11:43:59 CST