Re: oracle generated numbers are being store in scientific notation.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 05 Apr 2005 18:47:18 +0200
Message-ID: <97g551h1dj7r5urf1b5bor7gss9i2aurol@4ax.com>

On 5 Apr 2005 09:15:37 -0700, lcwcode_at_hotmail.com wrote:

>OUR DBA created a column that is defined as number(20)that
>automatically generates the numbers for this column. Some of the
>numbers are being stored in scientific notation. What does this mean?
>We need to define this column as another type? It seems like it has
>reached the limits that oracle will allow. Any info will help because
>I'm not a database person I just want to make sure this will not cause
>us any problems. I know it's using the auto generate feature in Oracle.

Numbers will display in scientific format when the format model is not wide enough. The default is 10 positions.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Apr 05 2005 - 11:47:18 CDT