Re: SQl Load question about decimal comma is point

From: me zawadzki <markz-nospam-_at_starnet.lenfest.com>
Date: Wed, 30 Jun 1999 13:37:55 -0400
Message-ID: <377A55F3.C7387BB3@starnet.lenfest.com>

If the column were named salary, then the control filefor this would be (assume all fields terminated by '|') : LOAD DATA
INFILE WHATEVER
INTO TABLE WHATEVER
FIELDS TERMINATED BY '|'
( salary CHAR "REPLACE(:salary, ',', '.')")

---

you can use just about any appropriate SQLPLUS function w/in double quotes and with the column name prepended with colon (:).

Monique van Daal wrote:
>
> We want to load a file with amounts.
> In the external file the amount are define as 999999,99 in stead of
> 999999.99 (look at the comma and the point as decimal)
> How can we translate in SQLload the comma to a point?
>
> thanks in advance

--
ÐÏࡱá Received on Wed Jun 30 1999 - 12:37:55 CDT