Re: Numerical Data Size

From: Jan H Malmberg <jhma_at_gbg.ifsab.se>
Date: Thu, 29 Apr 1999 08:24:24 +0200
Message-ID: <7g8u25$sbn$1@vega.lejonet.se>

A number is declared as NUMBER(precision, scale) where precision is the total number of digits and scale is the number of digits to the right of the decimal point.

I would prefer to declare numbers as NUMBER without any definition of precision and scale and let the clients handle the formating. In this way you will always be able to store any number in the column.

/JhMa
Julia Cristina Varela de Montoya <jc_va_at_hotmail.com> wrote in message news: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 Thu Apr 29 1999 - 01:24:24 CDT