| SQL*Loader [message #150453] |
Thu, 08 December 2005 00:01  |
sundaju
Messages: 2
Registered: December 2005
Location: Doha
|
Junior Member |
|
|
I have a table as follows
Table1
ColA VARCHAR2(5)
ColB NUMBER(7,2)
and I have a fixed width data file with data as given below
AABBC0098765
The data file contents are being interpreted as follows
First 5 characters go into ColA as it is
The next 7 digit should be parsed so that it goes into ColB as 987.65
Here the decimal point is not provided explicitly as part of the data file..
How do I load this type of data into tables using SQL Loader?
Any help is greatly appreciated...
Thanks
Sundar
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
