| Re: SQL*Loader - Loading weird number format [message #368126] |
Wed, 16 August 2000 12:20 |
JOHN
Messages: 182
Registered: April 1998
|
Senior Member |
|
|
Mark,
You posted this awhile ago. Are you still having the problem? If you are - here is one solution.
Add a column to the table you are importing to as a varchar2. Import the 'offending' numeric
value into this column with the trailing '-' or ' ' just as it comes from the import file.
Write a before insert trigger on the table that
'converts' the character based number using the
last character as a multiplier. If the last character is '-' do (xx.xx * -1) else (xx.xx * 1).
You can do this with a decode process on the character column.
I have been through this before and it works. If you need help with the decode, e-mail me.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
