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.
[EMAIL PROTECTED]
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-----
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
