Home » RDBMS Server » Server Utilities » Please help with sqlldr conversion problem
Please help with sqlldr conversion problem [message #368117] Sat, 05 August 2000 14:03 Go to next message
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
Re: Please help with sqlldr conversion problem [message #368122 is a reply to message #368117] Tue, 08 August 2000 08:54 Go to previous message
Mohammad Islam
Messages: 1
Registered: August 2000
Junior Member
Reply urgently.
Previous Topic: Urgent: SQL*Loader-562: record-size is too large
Next Topic: import on IBM AIX machine
Goto Forum:
  


Current Time: Thu Mar 28 03:32:19 CDT 2024