Re: Oracle size of numeric fields?

From: Jonathan Ingram <jonathan.ingram_at_miname.com>
Date: Thu, 06 May 1999 16:44:16 GMT
Message-ID: <3731C6A4.3C17DA6B@miname.com>

Colinou wrote:

> does Oracle attribute a size (length) to numeric fields?

From the Oracle7 Server SQL Reference (direct quote, except where I had to explain powers):

"The NUMBER datatype is used to store zero, positive, and negative fixed and floating point numbers with magnitudes between 1.0 X10 to the -130th power and 9.9...9x10 to the 125th power (38 9s followed by 88 0s) with 38 digits of precision."

Jonathan Ingram
jonathan.ingram_at_miname.com
Remove the first "m" from "miname.com" to reply. Received on Thu May 06 1999 - 11:44:16 CDT