Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help!!! Urgent Query on size limit of Number type field

Help!!! Urgent Query on size limit of Number type field

From: Kanv <kanvpandit_at_hotmail.com>
Date: 24 Mar 2003 05:47:43 -0800
Message-ID: <2554c5c7.0303240547.4285382b@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US