RE: Number of bytes used by number data type

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 19 Mar 2003 17:19:03 -0600
Message-Id: <24715.322457@fatcity.com>

RJ - The simplest way is to perform simple experiments such as the following:
Too late in the day to convert this to a formula.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

SQL> select vsize(to_number(99)) from dual;

VSIZE(TO_NUMBER(99))

---

                   2

SQL> c/99/999/
  1* select vsize(to_number(999)) from dual SQL> r
  1* select vsize(to_number(999)) from dual

VSIZE(TO_NUMBER(999))

---

                    3

SQL> c/999/9999/
  1* select vsize(to_number(9999)) from dual SQL> r
  1* select vsize(to_number(9999)) from dual

VSIZE(TO_NUMBER(9999))

---

                     3

SQL>                    

-----Original Message-----
From: Rishi.Jain_at_VerizonWireless.com
[mailto:Rishi.Jain_at_VerizonWireless.com]
Sent: Wednesday, March 19, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L Subject: Number of bytes used by number data type

Guru's

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 .

A quick response would be highly appreciated

RJ
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Rishi.Jain_at_VerizonWireless.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 19 2003 - 17:19:03 CST