| A question about NUMBER datatype [message #50009] |
Fri, 22 February 2002 18:37  |
Kishore
Messages: 45
Registered: September 2000
|
Member |
|
|
Hi,
I am trying to insert a value 1234567.89 into a column of datatype NUMBER(9,3). It's failing with an error that the value is larger than expected. Could you please let me know, why?
Thanks in advance,
Kishore
|
|
|
|
| Re: A question about NUMBER datatype [message #50036 is a reply to message #50009] |
Mon, 25 February 2002 04:26  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
|
When you define 9,3, you have stated that you have a 6 digit # with 3 decimal place (9-3 = 6). so by inserting a 7 digit number you are over the maximum allowed by one digit. in this case the biggest # you can insert is 999999.999.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
