Re: Best Number Representation for Money

blyons3_at_gmail.com wrote:
> Hello all,
>
> Is there any convention for representing money with an Oracle Database?
> I'll throw out NUMBER(4, 19) as an ice breaker to get the conversation
> started.

i think you mean (19,4).

but as Jim wrote, it depends what do you want to do with these numbers. calculating / converting needs more decimal places (AFAIK 4) than just storing (0-3).

regards,
-ap Received on Sat Jul 22 2006 - 04:53:43 CDT