Re: Sql*ldr and float dataformat

ranne schreef:

> 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?

In your original posting, you wanted a language setting. NLS_NUMERIC_CHARACTERS
is just (a part of) that.
If you do not want to use NLS_NUMERIC_CHARACTERS, use an appropiate NLS_LANG
setting - one governs the other.
My guess is, you should use AMERICAN_AMERICA. Of course, changing your format mask to (

        ANNUAL_RENT "to_number(trim(:ANNUAL_RENT), '9,999,999,999,999,999,999.9999')", would help if your group separator is ","

Chapters 5 and 6 of the utilities manual - sqlldr 8| Received on Wed Aug 16 2006 - 16:10:31 CEST