Re: Difference between DESC & user_tab_columns

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)