Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Number of bytes used by number data type

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>

<P><FONT SIZE=2>The contents of a number column will vary in size, depending on the number of significant digits.</FONT>
<BR><FONT SIZE=2>Try select avg (vsize (column)) from table ;</FONT>
</P>

<P><FONT SIZE=2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt; From: Rishi.Jain_at_VerizonWireless.com</FONT>
<BR><FONT SIZE=2>&gt; [<A HREF="mailto:Rishi.Jain_at_VerizonWireless.com">mailto:Rishi.Jain_at_VerizonWireless.com</A>]</FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; I want to find out the exact space occupied by a number </FONT>
<BR><FONT SIZE=2>&gt; field. E.g I want to</FONT>
<BR><FONT SIZE=2>&gt; find out the space occupied by a field </FONT>
<BR><FONT SIZE=2>&gt; NUMBER(7,2). I know oracle has an alogorithm to figure that out . </FONT>
</P>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US