Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help!!! Urgent Query on size limit of Number type field
I have a few critical tables containing Number type fields
[Number(18,3)]. But when an attempt is made to insert a number in the
format of 14 intergers, one decimal point and 3 decimal values (all
adding upto 18), it truncates the decimal values refuses to insert the
amount sometimes. Whats going wrong here? Is there a limit to the
number of decimals which can be stored? whats the limit for a number
type field?
Received on Mon Mar 24 2003 - 07:47:43 CST