Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> help formatting a string to number

help formatting a string to number

From: Dominick LoGiudice <dlogiudice_at_pine.vpcc.sunysb.edu>
Date: Sat, 12 Sep 1998 09:49:18 -0400
Message-ID: <35FA7BDE.CD2A5C31@pine.vpcc.sunysb.edu>


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 Received on Sat Sep 12 1998 - 08:49:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US