Re: Number(30)

From: <romeo.olympia_at_gmail.com>
Date: 3 May 2007 00:05:57 -0700
Message-ID: <1178175957.190086.288370@l77g2000hsb.googlegroups.com>

On May 3, 2:30 pm, val <minnie_ngu..._at_yahoo.com> 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!

number(30) would store that long number properly. It's probably a display issue.

Are you using sqlplus to submit your select query? Try the COL command to set the display format and length.

Cheers,

Romeo Received on Thu May 03 2007 - 02:05:57 CDT