Re: describe
From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Fri, 26 Apr 2002 15:17:59 GMT
Message-ID: <3CC96FA4.D2176C2F_at_exesolutions.com>
Date: Fri, 26 Apr 2002 15:17:59 GMT
Message-ID: <3CC96FA4.D2176C2F_at_exesolutions.com>
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!
[Quoted] 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 Fri Apr 26 2002 - 17:17:59 CEST