Re: Size of datatype NUMBER

From: Ed Prochak <edprochak_at_gmail.com>
Date: Wed, 25 Feb 2009 07:09:35 -0800 (PST)
Message-ID: <9ba4ad58-e871-4c0a-a7ec-3fbc835d7a20_at_z9g2000yqi.googlegroups.com>

On Feb 25, 8:25 am, Norbert Pürringer <thalio..._at_graffiti.net> wrote:
> Hello,
>
> what is the size of the Oracle datatype NUMBER in bytes?
>
> Thank you,
> Norbert

At
 http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref81  the manual states:
<q>
NUMBER Datatype

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. </q>

If you don't specify the precision when declaring the column, then the default is the max, 22bytes.

Reading the manual is a great way to answer these questions for yourself.
  Ed Received on Wed Feb 25 2009 - 09:09:35 CST