Re: How to tell oracle SQL*Loader thousand seperating character?

Christian,

I think this is similar to a question that came up recently. It won't work with an external table, but will with sqlldr

IIRC, for the following data file :-

1|111.111,0
2|456.123,5

I think you can do something like this, which is valid sqlldr syntax :-

LOAD DATA
INFILE 'test.txt'
TRUNCATE
INTO TABLE doug_test
FIELDS TERMINATED BY "|"

	(pk,
	test_value CHAR "TO_NUMBER(:test_value, '999,990.90',
			'NLS_NUMERIC_CHARACTERS = '',.''')"

HTH,

--
Doug Burns - Oracle DBA

dougburns_at_yahoo.com

http://doug.burns.tripod.com
http://oracledoug.blogspot.com