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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [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).
