Re: NUMBER datatype

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 18 Aug 1999 18:27:54 +0800
Message-ID: <37BA8AAA.71EF@yahoo.com>

gregk72_at_my-deja.com wrote:
>
> When I do a Analyze table on table with Number datatypes in it, the
> statistics always come back indicating that number fields take 22 bytes
> regardless of the precision and scale indicated when creating the
> column. Do NUMBER fields ALWAYS take 22 bytes??
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

No - check the Server Concepts manual...

Number format only uses enough bytes to store that number...

thus the value of "1" in a NUMBER(10) column uses the same amount of data as in a NUMBER(2) column...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Aug 18 1999 - 05:27:54 CDT