Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How many bytes does the datatype NUMBER use?

Re: How many bytes does the datatype NUMBER use?

From: Deana Strbevski <deana.strbevski_at_ina.hr>
Date: Mon, 14 Feb 2000 11:43:42 +0100
Message-ID: <38A7DC5E.E89DDA16@ina.hr>


Hi !

p = mantissa (scale has no effect) Example : 512

1 byte 		(exponent)		   	1 byte
floor(p/2) + 1 	(mantissa)		floor(3/2)+1 = 2
+1 byte   	(only for negative)		-
------------------                      ------------------
number of bytes					3 bytes


Souce : ORACLE7 Server, Concept Manual

Louis Frolio wrote:
>
> Greetings All, I was hoping that someone might be able to tell
> me how many bytes the datatype "number" uses. If it is dynamic
> what is the method of determinig how many bytes will be used?
>
> Thank You, Louis
> frolio_at_videoshare.com
Received on Mon Feb 14 2000 - 04:43:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US