Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.ision.net!newsfeed2.easynews.net!ision!newsfeed01.sul.t-online.de!t-online.de!netnews.web.de!npeer.de.kpn-eurorings.net!npeer0.kpn.DE!newsfeed.arcor.de!newsspool2.arcor-online.net!news.arcor.de.POSTED!not-for-mail
Message-ID: <461359A5.7060606@arcor.de>
Date: Wed, 04 Apr 2007 09:54:13 +0200
From: Maxim Demenko <mdemenko@arcor.de>
Reply-To:  mdemenko@gmail.com
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
To: Anil <anil.malyala@gmail.com>
Subject: Re: How to store 2^128 value in oracle
References: <1175639010.194646.157230@b75g2000hsg.googlegroups.com>
In-Reply-To: <1175639010.194646.157230@b75g2000hsg.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 24
Organization: Arcor
NNTP-Posting-Date: 04 Apr 2007 09:58:27 CEST
NNTP-Posting-Host: 61a702f7.newsspool2.arcor-online.net
X-Trace: DXC=1aNOiM:lOic]l@YUW5NBknA9EHlD;3Ycb4Fo<]lROoRa8kF<OcfhCOk]XkJ>C\d2je?260c7o_eEjfb[YG8XaEeh;ZoH<8FPU7`
X-Complaints-To: usenet-abuse@arcor.de
Xref: news.f.de.plusline.net comp.databases.oracle.misc:78644

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