Re: What does a table look like?

desc TABLE_NAME works as well.

For example

SQL> desc all_users

 Name                            Null?    Type
 ------------------------------- -------- ----
 USERNAME                        NOT NULL VARCHAR2(30)
 USER_ID                         NOT NULL NUMBER
 CREATED                         NOT NULL DATE
 

SQL> enduser_at_enduser.com (EndUser) wrote:

>log on as system/manager, select * from tab, gets all tables.
>select * from syscolumns where tabname = 'xxx' gets you columns.
>look in the back of your dba ref to see all system views, else, you
>can see the list of views as they spill out of the system/manager tab
>select.
 

>--
 

>In article <49cqgc$hcp_at_ams.amsinc.com>, joel_nylund_at_mail.amsinc.com (Joel
>Nylund) wrote:
 

>> I am new to oracle, I need to find out what the schema of a table looks
>>
>> like. In sybase I can do a "sp_help" which gives all of the column names
>>
>> and their attributes.
>>
>> Is there an easy way to do this in oracle?
>>
>>
>> thanks in advance
>> Joel

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government Received on Mon Nov 27 1995 - 00:00:00 CET