Re: number(p,s)

From: Danisment UNAL <danisment_at_yahoo.com>
Date: Mon, 19 Feb 2001 07:51:08 -0800
Message-ID: <F001.002B7E58.20010219073123@fatcity.com>

Selam,

Number represantation is not a byte-to-byte represantation like characters'. If it was so, 1234567 occupies 7 bytes. in fact, it's less (I guess). you can check it by dump function in sql*plus.

Oracle uses mantisa/exponent notation to store numeric data like OS does. this notation not only saves space, but also holds huge numeric data from negative values to positive values.

there should be a note in metalink which explains details with samples.

hope this helps...

• "Bunyamin K.Karadeniz" <bunyamink_at_havelsan.com.tr> wrote:
  > number(p,s) datatype conflicts my mind.
  >
  > every book tells that -84 < s < 127
  >
  > How can s be minus. Negative scale??
  >
  >
  >
  >
  

  ---

---

Danisment Gazi Unal
Web: http://www.geocities.com/danisment

---

---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment UNAL
  INET: danisment_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Feb 19 2001 - 09:51:08 CST