| Please help with sqlldr conversion problem [message #368117] |
Sat, 05 August 2000 14:03  |
Kevin
Messages: 45
Registered: February 2000
|
Member |
|
|
Hello,
I don't know how to import a tab delimited numeric column into an Oracle database.
Example of original file is:
col1 col2 col3
where col1 and col3 are texts and
col2 is a numeric column where datas are:
45,000.99
- 45,000.78(notice a space between), etc..
There is a blank space between the sign(-) and the number(45,000.78) so when I tried to load into database I am getting invalid number due to space.
I created col2 column in the table in this format:
col2 number(9,2)
My loader field specification is:
col2 char "to_number(:col2, '99,999.99')"
Also I am not allowed to change anything in the original file which is in .dat format so space remains.
Is there any way to load col2 into the database with some manipulation in the ctl file because I need to do sorts in the database?
Thanks..
kevin
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
