REPOST: sqlldr decimal to number conversion
From: Murat <muratmy_at_hotmail.com>
Date: 25 Jan 2002 07:13:43 -0800
Message-ID: <3$--$%%%_$_$_-_$-$_at_news.noc.cabal.int>
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)
Date: 25 Jan 2002 07:13:43 -0800
Message-ID: <3$--$%%%_$_$_-_$-$_at_news.noc.cabal.int>
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: muratmy_at_hotmail.com (Murat) Control: cancel <ee690240.0201250713.4dc70f58_at_posting.google.com> Subject: cmsg cancel <ee690240.0201250713.4dc70f58_at_posting.google.com> Date: Mon, 28 Jan 2002 00:50:36 GMT Message-ID: <cancel.ee690240.0201250713.4dc70f58_at_posting.google.com> 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!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40718681
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:13:43 CET