Re: How to store 2^128 value in oracle

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 04 Apr 2007 09:54:13 +0200
Message-ID: <461359A5.7060606@arcor.de>

Anil schrieb:
> I need to store a value equal to 2^128 in an oracle or sybase
> database.
> looks like neither of them support that big of a number.
> Any one has any idea on how to achieve this?
> Thanks,
> Anil
>

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref80 <cite>
The NUMBER datatype stores zero as well as positive and negative fixed numbers with absolute values from 1.0 x 10^-130 to (but not including) 1.0 x 10^126. If you specify an arithmetic expression whose value has an absolute value greater than or equal to 1.0 x 10^126, then Oracle returns an error. Each NUMBER value requires from 1 to 22 bytes. </cite>

I used to think, 2^128 is nearly 10^38, what is far less than upper limit for number datatype.

Best regards

Maxim Received on Wed Apr 04 2007 - 02:54:13 CDT