REPOST: Re: sqlldr decimal to number conversion

Hi,

Look following example:

LOAD DATA
INFILE *
INTO TABLE name_yours_table
FIELD TERMINATED BY '|'
( col1 CHAR "to_number(:col1,'9999D0','NLS_NUMERIC_CHARACTERS='',.''')",

   col2 CHAR "to_number(:col2,'9999D0','NLS_NUMERIC_CHARACTERS='',.''')",    col3
)
BEGINDATA

1.0|11.0|text1
3.0|23.0|text2
10.0|2.0|text3


	Slawas

Murat wrote:

> Hi ,
> is there a workaround for the sample data file below to load it with
> sqlldr into number(2) field.(getting rid of these ".0" s)
>
> 1.0|11.0|text1
> 3.0|23.0|text2
> 10.0|2.0|text3
>
> I see it is not possible to specify like "firmnr number(2)" in the
> .par file.
> Actually if I unset the environment variable NLS_LANG , sqlldr loads
> the data but when I set NLS_LANG=german_germany.we8iso8859p9 it turns
> an ORA-01722: invalid number error, I need any help....
>
> murat
>

• WAS CANCELLED BY =======: From: Slawomir Cichy <SlawasC_at_netscape.net> Control: cancel <3C517EB6.9020202_at_netscape.net> Subject: cmsg cancel <3C517EB6.9020202_at_netscape.net> Date: Mon, 28 Jan 2002 02:34:20 GMT Message-ID: <cancel.3C517EB6.9020202_at_netscape.net> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.tools NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!news-koe1.dfn.de!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40718484

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 16:50:14 CET