Re: help formatting a string to number

From: <bpena_at_my-dejanews.com>
Date: 1998/09/14
Message-ID: <6tjod9$f8t$1@nnrp1.dejanews.com>#1/1

In article <35FA7BDE.CD2A5C31_at_pine.vpcc.sunysb.edu>, dlogiudice_at_pine.vpcc.sunysb.edu wrote:
> 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
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 00:00:00 CDT