Hi,

We are using Oracle 8.1.6 on Windows 2000. Recently I came across Data type NUMBER difference. In User_Tab_Columns If data type is NUMBER it shows data length 22, Data Precision Null and Data Scale 0. Where as some places it shows data length 22, Data Precision 38 and Data Scale 0. Which is correct behavior?

Normally while creating table we don't define precision, scale value. Our standard script is as follows....

Create table Test (
No NUMBER,
TestId SmallInt,
Amount Integer)

Oracle treats rest ANSI numeric data types as number. Why it shows 22 in data length?

Please Help.

Thanks & Regards,

Shailesh