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 -> Re: How to tell oracle SQL*Loader thousand seperating character?

Re: How to tell oracle SQL*Loader thousand seperating character?

From: Christian Meier <tomtailor_at_freesurf.fr>
Date: 25 Sep 2005 11:37:41 -0700
Message-ID: <1127673461.390919.116760@g43g2000cwa.googlegroups.com>


But NLS_LANG is about character set isn't it? And do I realy have to change enviroments or Database globals? Isn't there a way like: FIELDS TERMINATED BY ";" DECIMAL ".," ?
define NLS_LANG in the Loader syntax fails LOAD DATA INFILE * and so on

In SQL Loader I could change charset with CHARACTERSET UTF8, but why should I change the Charset, it's OK. I'd like to change the comma and thousand point depending an Datasource not as a global or enviroment variable. Received on Sun Sep 25 2005 - 13:37:41 CDT

Original text of this message

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