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
>
Received on Fri Jan 25 2002 - 16:50:14 CET