Re: Difference between DESC & user_tab_columns

From: Praveen <nospam_at_nospam.com>
Date: Mon, 25 Oct 2004 12:52:29 -0700
Message-ID: <417D597D.5030508@nospam.com>

Hi..Daniel,

   But this doesn't work for Number field. The length in the user_tab_columns is different from DESC. Why?

DA Morgan wrote:
> Praveen wrote:
>
>

>>------------------------------------------------------------------------
>>

>
>
> desc <table_name>
>
> SELECT column_name, DECODE(nullable, 'N', 'NOT NULL', NULL) "Null?",
> data_type || '(' || data_length || ')' TYPE
> FROM user_tab_columns
> WHERE table_name = <table_name>
>
> No difference except a column title and that's easily fixed.
>
Received on Mon Oct 25 2004 - 14:52:29 CDT