Re: Sql*ldr and float dataformat

From: ranne <krieide_at_gmail.com>
Date: 16 Aug 2006 06:34:49 -0700
Message-ID: <1155735289.180820.297160_at_h48g2000cwc.googlegroups.com>


frank.van.bortel_at_gmail.com skrev:
> ranne schreef:
>
>
> > Windows XP
> > *********************
> > Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> > PL/SQL Release 9.2.0.5.0 - Production
> > CORE 9.2.0.6.0 Production
> > TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
> > NLSRTL Version 9.2.0.5.0 - Production
>
> Before you start the SQL*Loader session (sqlldr.exe on WinXP), set
> you NLS parameters.
> set NLS_NUMERIC_CHARACTERS='.,' should do the trick (although I
> always forget what's what, so maybe you should try ',.')

thanks alot.. :) I'll sure try that.
is it any way to do anything similar by adding code to the ctl-file? Received on Wed Aug 16 2006 - 15:34:49 CEST

Original text of this message