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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
>
> 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 .
