Re: describe
From: Bill Thorsteinson <billthor_at_yahoo.com>
Date: Fri, 26 Apr 2002 21:34:20 -0400
Message-ID: <kvvjcu0ah40uh1pg38kujt0ueu8j7kmc2f_at_4ax.com>
Date: Fri, 26 Apr 2002 21:34:20 -0400
Message-ID: <kvvjcu0ah40uh1pg38kujt0ueu8j7kmc2f_at_4ax.com>
On Fri, 26 Apr 2002 15:17:59 GMT, Daniel Morgan <damorgan_at_exesolutions.com> wrote:
>Carmine wrote:
>
>> hi NG
>> i want to know,please, how can i obtain field's type of a table?Is there a
>> sql statement to solve this problem?
>> thanks!
Try the SQLPlus describe command
DESCRIBE my_table
>
>You need to invest some time in learning the Oracle data dictionary.
>
>In this case the information you want is in xxx_tab_columns where you can
>substitute user, all, or dba for xxx.
>
>If you wanted index information xxx_ind_columns.
>
>If you wanted constraints xxx_cons_columns.
>
>Daniel Morgan
Received on Sat Apr 27 2002 - 03:34:20 CEST