Re: help formatting a string to number

Hi Dominick,

    You really aren't providing enough information to enable a positive identification of the problem. The first two things to check are:

1. You say in the text that you have defined the column in the table as 12V6 but your example is showing '555555555555123456' which requires a definition of 18V6 since the first value must define the entire length including decimal positions.
2. You don't say whether or not you are using using the SQL*Loader. If so, did you use a format in your control file? From what I remember the format '999999999999V999999' should work.

regards

Jerry

Dominick LoGiudice wrote in message
<35FA7BDE.CD2A5C31_at_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 Mon Sep 14 1998 - 07:45:01 CDT