Re: Beginner question

From: <rock_cogar_at_my-deja.com>
Date: Fri, 17 Dec 1999 14:52:35 GMT
Message-ID: <83ding$q8v$1@nnrp1.deja.com>

To get all columns for all tables owned by user SCOTT:

select * from dba_tab_columns where owner = 'SCOTT';

2. To get all tables owned by user SCOTT:

select * from dba_tables where owner = 'SCOTT';

In article <83dh1d$ose$1_at_nnrp1.deja.com>, texas_mike_at_my-deja.com wrote:
> What is the SQL command used to find the list of tables in the
database
> and to find the list of fields in the tables? Isn't there a system
> table that can be queried?
>
> Thanks.
>
> --
> -----------------------------
> TEXAS_MIKE_at_MY-DEJANEWS.COM
> Hey haven't we met?
> -----------------------
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 08:52:35 CST