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

Home -> Community -> Usenet -> c.d.o.server -> SQl Load question about decimal comma is point

SQl Load question about decimal comma is point

From: Monique van Daal <mvdaal_at_hotmail.com>
Date: Wed, 23 Jun 1999 08:55:59 GMT
Message-ID: <37709f78.5521605@news.atriserv.nl>


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 23 1999 - 03:55:59 CDT

Original text of this message

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