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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 Oct 2001 23:39:38 +0100
Message-ID: <7vautt0retdrdjan6e7tvmhlm0aa4u39nr@4ax.com>

On Tue, 30 Oct 2001 13:30:34 -0600, Huntress <kaeli96_at_yahoo.com> wrote:

>
>
>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~

The manual is online at http://technet.oracle.com You'll need a free subscription to access it.

If you got Oracle on CD, a manual usually is included.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 30 2001 - 16:39:38 CST