Jim Kennedy schreef:
> <blyons3_at_gmail.com> wrote in message
> news:1153519027.508659.89700_at_b28g2000cwb.googlegroups.com...
>> 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.
>>
>> Thanks,
>> Bill
>> blyons3_at_yahoo.com
>>
> Depends upon the units. If you are dealing with Yen then the precision
> would be 0. If you are dealing with US Dollars then 2 digits of precision.
> I am assuming that you can't have fractional units. (eg fractions of a
> penny, fractions of a yen.) It really depends upon your requirements.
> Jim
>
>
Unless you take the smallest unit possible. Cents would do nicely in the
USA and European Monetary Union.
Money is NOT a datatype. Use number.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sat Jul 22 2006 - 04:20:46 CDT
