[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Need Help with numeric formatting

divide it by 1,000,000!

Dominick LoGiudice wrote:
>
> I might have sent this message before
>
> I have an input file with field the has a field
> description of 12v6 (12digits)implied decimal (6 digits)
> If I look at the data it looks like this
> 555555555555123456.
> I am trying to load this into an oracle db. The field on
> the table is also 12v6.  I am getting  an oracle error
> because the the field is being loaded with all 18 digits
> to the left of the decimal.
> How do I format it as 555555555555.123456
> Thanks

--

Greg

One person can make a difference...
but most of the time they probably shouldn't

http://www.seanet.com/~ggargett