Re: Number(10)
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 05 Jan 2000 20:56:08 +0800
Message-ID: <38733F68.524F_at_yahoo.com>
Date: Wed, 05 Jan 2000 20:56:08 +0800
Message-ID: <38733F68.524F_at_yahoo.com>
Frank van Bortel wrote:
>
> William Teo wrote:
>
> > Hi,
> >
> > Could anyone provide the answer?
> > Number(10), Number(20), Number(20,5)
> >
> > So how much spae was used on the Server for each case?
>
> AFAIK, 38. All numbers are always in 38 precision. All you do, is
> adding some "format mask" to make it accept only 10 or 20 positions.
> --
> Met vriendelijke groet/kind regards,
>
> Frank van Bortel
> Technical consultant Oracle
This is the maximum that will be stored but typicall this will be much much lower...Numbers in oracle only use as many bytes as required..
HTH
-- =========================================== Connor McDonald "These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com "Some days you're the pigeon, and some days you're the statue."Received on Wed Jan 05 2000 - 13:56:08 CET