Re: Difference between DESC & user_tab_columns

On Fri, 22 Oct 2004 12:46:40 -0700, Praveen <nospam_at_nospam.com> wrote:

>Hi..All,
>
> When I do a DESC on a table , one of the columns shows the
>datatype(lenght) as Number(38). But when I look at the details of the
>column it shows something else. How does it come up with a different
>lenght Or where does desc pick it from when you do a DESC? Is there any
>other logic involved?

Your question can be answered by reading up on how number columns are stored.
Please try to read the manual prior to posting, and please STOP your CONSISTENT RUDE cross and multiposting policy.

--
Sybrand Bakker, Senior Oracle DBA