Oracle 10g R 10.2.0.3, Windows 2003 Server

I know if I have a VARCHAR2(50) column and I update it from a 15 character
string to 25 character string that I'll use more storage space in the data
blocks.

If I have a NUMERIC(10) column and I update it from a 0 value to a non-zero
value will that use more storage space or will the allocation for it being
NUMERIC(10) already have the storage space allocated?

Thanks.

P.S.: What is it with all these MI5 posts?

Dereck L. Dietz wrote:
> Oracle 10g R 10.2.0.3, Windows 2003 Server
>
> I know if I have a VARCHAR2(50) column and I update it from a 15 character
> string to 25 character string that I'll use more storage space in the data
> blocks.
>
> If I have a NUMERIC(10) column and I update it from a 0 value to a non-zero
> value will that use more storage space or will the allocation for it being
> NUMERIC(10) already have the storage space allocated?
>
> Thanks.
>
> P.S.: What is it with all these MI5 posts?

Depends. To determine how a number responds use DUMP.

SELECT dump(1) FROM dual;
SELECT dump(10) FROM dual;
SELECT dump(100) FROM dual;
SELECT dump(1000) FROM dual;
SELECT dump(1.1) FROM dual;
SELECT dump(1.11) FROM dual;
SELECT dump(11.111) FROM dual;

MI5? Some synapse-free troll. Please join us in reporting to spamcops
or other.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Dereck L. Dietz wrote:
> Oracle 10g R 10.2.0.3, Windows 2003 Server
>
> I know if I have a VARCHAR2(50) column and I update it from a 15 character
> string to 25 character string that I'll use more storage space in the data
> blocks.
>
> If I have a NUMERIC(10) column and I update it from a 0 value to a non-zero
> value will that use more storage space or will the allocation for it being
> NUMERIC(10) already have the storage space allocated?
>
> Thanks.
>
> P.S.: What is it with all these MI5 posts?
>
>

Numbers are stored as a mantissa and exponent. If the size of those do
not change, then your storage requirements do not change.

Metalink Note:143256.1 has some more details which may be of interest to
you.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com