-
Data Type NUMBER length 38 Or 22....???
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|