Re: EASY ???? Viewing table info from sqlplus .. HOW

From: Troy Clark <troydata_at_phnx.uswest.net>
Date: Sat, 19 Jun 1999 18:08:12 -0700
Message-ID: <n9Xa3.110476$uo1.326980_at_news.uswest.net>


From SQLPlus you would execute

    desc mytable;
And it will show you the definition of the table (columns, types, etc.)

There is tons of info available via the v$ and dba_ views.

Dr. Jan Dieckmann wrote in message <376A5C3A.3844CFC4_at_psi.de>...
>If you like to have more comfort try a tool like Hora 3. See
>http://www.keeptool.com for a free trial version of Hora.
>
>regards Jan Dieckmann
>
>Clarence Hart Jr. wrote:
>
>> Hello
>> I'm sorry for asking such a simple Q but I dont know how to do this....
>>
>> Q.
>>
>> How do you view the info such as datatypes or defined views and stuff
>> from sqlplus.
>>
>> ( In SYBASE its sp_help database or tablename)
>>
>> What is it in ORACLE?
>>
>> Thanks
>>
>> Clarence Hart
>> clh_at_ismd.ups.com
>
>
>
Received on Sun Jun 20 1999 - 03:08:12 CEST

Original text of this message