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

Need Help with numeric formatting

Subject: Need Help with numeric formatting
From: Dominick LoGiudice <dlogiudice@PINE.VPCC.SUNYSB.EDU>
Date: Thu, 10 Sep 1998 21:03:10 -0400
Organization: I am at home
References: <006b01bddd0b$81f15ee0$0c2ad6c6@IS_09237.tdhca.state.tx.us>

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

Follow-Ups:
- Re: Need Help with numeric formatting
  - From: Greg Gargett <ggargett@SEANET.COM>
- Re: Need Help with numeric formatting
  - From: Mario Insigne <minsigne@CCSF.CC.CA.US>

References:
- Re: Calling an SQR from the WEB
  - From: Gracen Duffield <itzgee@PRISMNET.COM>

Prev by Date: Re: Can SQR get current values off of a Peoplesoft panel group?
Next by Date: Re: bar codes
Prev by thread: Re: Calling an SQR from the WEB
Next by thread: Re: Need Help with numeric formatting
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page