Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: EASY ???? Viewing table info from sqlplus .. HOW

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US