Re: Storage Allocation Question

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org