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

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 Sat Jun 19 1999 - 20:08:12 CDT