Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Numerical Data Size
The first number (ie. 4) specifies the total length of the number, ie. the
digits before the decimal point plus the digits after the decimal point. The
second number (ie. 2) specifies the length of digits after the decimal
point.
HTH
Julia Cristina Varela de Montoya wrote in message
<7g89gm$gjf$1_at_bgtnsc01.worldnet.att.net>...
> I ran a sql loader today. I insert a flat file with numerical data
that
>was as such: 99.99, including the decimal. It never exceed 2,2 in every
>case. I defined the table column as DECIMAL(2,2). I got an error on the
>load, and could only load it when I make the column DECIMAL(4,2) Can
>someone tell me why I need DECIMAL(4,2) for xx.yy? Thank you very much.
>
>
Received on Wed Apr 28 1999 - 20:28:40 CDT