Re: Number(30)

val wrote:
> 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!

You need to format the output.
www.psoug.org
Morgan's Library
click on SQL*Plus

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org