Message-Id: <24715.322456@fatcity.com> From: Jacques Kilchoer Date: Wed, 19 Mar 2003 15:14:34 -0800 Subject: RE: Number of bytes used by number data type This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C2EE6D.4DD31400 Content-Type: text/plain; charset="iso-8859-1" The contents of a number column will vary in size, depending on the number of significant digits. Try select avg (vsize (column)) from table ; > -----Original Message----- > From: Rishi.Jain@VerizonWireless.com > [mailto:Rishi.Jain@VerizonWireless.com] > > I want to find out the exact space occupied by a number > field. E.g I want to > find out the space occupied by a field > NUMBER(7,2). I know oracle has an alogorithm to figure that out . ------_=_NextPart_001_01C2EE6D.4DD31400 Content-Type: text/html; charset="iso-8859-1" RE: Number of bytes used by number data type

The contents of a number column will vary in size, depending on the number of significant digits.
Try select avg (vsize (column)) from table ;

> -----Original Message-----
> From: Rishi.Jain@VerizonWireless.com
> [mailto:Rishi.Jain@VerizonWireless.com]
>
> I want to find out the exact space occupied by a number
> field. E.g I want to
> find out the space occupied by a field
> NUMBER(7,2). I know oracle has an alogorithm to figure that out .