finding the length of a "number" field

From: <jerwynn_at_my-dejanews.com>
Date: Sun, 07 Mar 1999 03:05:58 GMT
Message-ID: <7bsqei$m5$1@nnrp1.dejanews.com>

Hi,

I have created a table using the ff:

create table employee
( id number(7) PRIMARY KEY,
name varchar2(30),
salary number(8,2)
)

When I use SQL Plus: describe employee, the correct column definition is returned.

However, if I query from the user_tab_columns (or col) table/view, the data_length of the number fields is incorrect.

the data_length for columns with data type "number" is always 22. thus number(8,2) becomes number(22)
and number(7) becomes number(22).

If you know how to query the length of a field, please email or reply to this newsgroup

Thanks.

Jerwynn

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Mar 06 1999 - 21:05:58 CST