Re: Data Type
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 10 May 2002 14:33:35 GMT
Message-ID: <3TQC8.6377$L76.287_at_rwcrnsc53>
Date: Fri, 10 May 2002 14:33:35 GMT
Message-ID: <3TQC8.6377$L76.287_at_rwcrnsc53>
The -1 means 1/(10^ -1 ) or use a precision of 10. So trying to put a
number with precision to the hundredths in a place that is only going to
accept to the tenth is going to round as you saw. If you want it to tenths
then
NUMBER(4,1)
Jim
"Paramjeet" <delhiparam_at_yahoo.com> wrote in message
news:60dcb14.0205100517.735e0132_at_posting.google.com...
> i am not able get the result of entering the data into the col ,
> whose datatype id defined as NUMBER(4,-1) ,, i was entering 123.34
> and the data getting stored in the table is 120 ?? plz can someone
> explain the funda of -1.
Received on Fri May 10 2002 - 16:33:35 CEST