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 -> How to define the DecimalSeparator for SQL Loader Files

How to define the DecimalSeparator for SQL Loader Files

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Thu, 13 Jul 2006 12:01:16 +0200
Message-ID: <e19f8$44b6199e$d4badae4$6041@news.chello.at> 





Hello!



I would like to update datasets in an Oracle database by using SQL Loader 
files.



One big problem of mine is how to know, which DecimalSeparator an SQL Loader 
file needs to treat floating numbers correctly.



e.g.


71779.42|173686.93|


or


71779,42|173686,93|



Is there a possibility to upload floating numbers independent of country 
settings in Oracle? Perhaps the DecimalSeparator could be set in the CTL 
file but I don't find such a setting in the help file.



Robert 
Received on Thu Jul 13 2006 - 05:01:16 CDT












Original text of this message













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