Re: Database sizeing question - so how big is a number anyway?

Bob Fazio wrote:
>
> 22 bytes
>
> --
> Robert Fazio, Oracle DBA
> rfazio_at_home.com
> remove nospam from reply address
> http://24.8.218.197/
> "ken k" <khkachn_at_toadDIESPAMMER.net> wrote in message
> news:H%S35.482$BA1.1000118_at_news.abs.net...
> > Hi all,
> >
> > I am trying to come up with some predictions on how much disk
> > space a table and index is going to take. The table has one date field
> > (7 bytes, found that one) and some number(10,0) and number(5,0)
> > fields.
> > I found the Oracle documentation on how to estimate a table and
> > index size but have not idea how many bytes the number fields will
> > take. The documentation seems to think you are estimating the size
> > of an existing table, which is dumb IMHO. Does anyone know how
> > the size works for number data type?
> >
> > Thanks,
> >
> > Ken K
> >
> >

22 at the VERY most...The datatype only uses enough bytes to store to the significant digits required, thus '345' will take the same number of bytes in a NUMBER(3) or a NUMBER(20)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse