USER_TAB_COLUMNS vs DESCRIBE

From: Steve Lucord <steve.a.lucord_at_lmco.com>
Date: Wed, 01 Dec 1999 14:38:28 -0600
Message-ID: <38458744.EFE795CC@lmco.com>

I am attempting to create a data dictionary report via SQL*PLUS. Using the USER_TAB_COLUMNS view I am able to get the following output:

Data            Data      Data
Table Name                         Column
Name                                      Type            Length   Scale
Null
-------------------------       ------------------------------ ---------
------          -----     ----   ----
WTW_PERFORMANCE    ACTUAL_90_DAY_RETENTION     NUMBER   22
2       Y

DESCRIBE provides the following information for same table/column name:

 Name                                                Null?        Type
 -------------------------------           --------    ----

 ACTUAL_90_DAY_RETENTION                  NUMBER(3,2)

Does anyone know a way to format the Data Type/Data Length/Data Scale as NUMBER(3,2) using SQL*PLUS?

Thanks,

Steve Lucord Received on Wed Dec 01 1999 - 14:38:28 CST