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

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.

To find out how they are stored:

SELECT dump(<column_name>) FROM <table_name>;

To then view it try:

SQL> col <column_name> format 99999999999999999999

Then your SQL statement

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)