RE: Number of bytes used by number data type

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 19 Mar 2003 15:14:34 -0800
Message-Id: <24715.322456@fatcity.com>

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_at_VerizonWireless.com
> [mailto:Rishi.Jain_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: Number of bytes used by number data type</TITLE>
</HEAD>
<BODY>

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_at_VerizonWireless.com
 > [<A HREF="mailto:Rishi.Jain_at_VerizonWireless.com">mailto:Rishi.Jain_at_VerizonWireless.com</A>]
 > 
 > 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 . 


</BODY>
</HTML>
Received on Wed Mar 19 2003 - 17:14:34 CST