Re: Size of datatype NUMBER

From: Ed Prochak <>
Date: Wed, 25 Feb 2009 07:09:35 -0800 (PST)
Message-ID: <>

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

At  the manual states:
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

Original text of this message