hi,
we currently have a column in our table (oracle 9i) defined as
number(30). however, when we try to insert data that has 25 digits,
it stores the number as 1.7909364352007E23. can you let me know why
it has exponents versus loading the number as is with 25 digits? how
can i change the datatype to store 25 digits. varchar(30)?

thanks!

val wrote:
Oracle IS storing it as a 30-digit integer, exactly as you specified.
But, it is DISPLAYING it in exponential notation, because that is the
default for integers over a certain length. All arithmetic you do on
this value will work OK as a 30-digit integer.
If you want to display it other than in the default way (e.g. as 30
digits), look up TO_CHAR() in the documentation. This allows you to
specify the display format.

val wrote:
You need to format the output.
www.psoug.org
Morgan's Library
click on SQL*Plus
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org