Re: DESC tableName - need an SQL version...

From: Huntress <kaeli96_at_yahoo.com>
Date: Tue, 30 Oct 2001 13:30:34 -0600
Message-ID: <3BDEFFDA.F924E77@yahoo.com>

Mark Styles wrote:
>
> On Tue, 30 Oct 2001 11:16:52 -0600, Huntress <kaeli96_at_yahoo.com>
> wrote:
>
> >I am trying to write a script that lists all field names for my tables.
> >The thing is, the script is not SQLPlus, and can't use the DESC command.
> >It has to use standard SQL. Can anyone tell me a way to write an SQL
> >SELECT statement that will tell me all the field names for a table?
>
> look at tables USER_TAB_COLUMNS, ALL_TAB_COLUMNS

Thanks!

Where can I come by the names of all these tables I didn't know existed? I am a newbie who had Oracle shoved down her throat with no manual...

Is there a list somewhere of all the "common" tables (ones I didn't make) and what is in them...?

~kaeli~ Received on Tue Oct 30 2001 - 13:30:34 CST