Q:SQL*Loader number format

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Thu, 09 Dec 2004 17:25:21 +0100
Message-ID: <41b87c71$0$16034$9b4e6d93@newsread4.arcor-online.net>

Hello

I've got a big flat file with # as separator. There is a number field which has negative sign at the end or nothing if it is a positive number:

D#100,00#100,00#BET
S#100,00-#100,00-#WISH In the database the field is a number(15,2)

I try to load this file with sql-loader, but earn always errors like invalid number ...

I try (seen at ask tom)
column_name "to_number( :column_name, '9999999999s' )/100", or
column_name "to_number( :column_name, '99999999D99MI' )",

nothing works correctly. In some cases i got the positive numbers but not the negative ones.

Is there someone who can help me to climb this little rock?

thanks
ralf Received on Thu Dec 09 2004 - 10:25:21 CST