Re: Beginner question

From: Roger Stapley <rstapley_at_uk.oracle.com>
Date: Fri, 17 Dec 1999 14:52:22 +0000
Message-ID: <385A4E26.55DFCB6F@uk.oracle.com>

You can use

select table_name from all_tables (or user_tables)

and select table_name, column_name from all_tab_columns where table_name = 'TABLE' 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.
Received on Fri Dec 17 1999 - 08:52:22 CST