Posted on 2013-01-30
I have an input file which contains the below columns namely ,
Name, DataofJoin,emailid, address
s1,2001-03-01 00:00:00.000, email@example.com chr(10) chr(13)firstname.lastname@example.org,s1chr(10)3rdstreet
s2,2002-05-02 00:10:00.000,email@example.com chr(10) chr(13)firstname.lastname@example.org,s2chr(10)3rdstreet
iam new to using sqlloader , I need help in creating the control file for loading the above data. The problem is that, in the columns of date of join , I have a 3 Milli seconds , that I have to convert to oracle format timestamps format , columns email id and address have character 13 and character 10 in between the values for the respective columns . I need to replace them with a space.
Another problem iam facing is that the records appear in two lines because of the newline and the form feed character. Before loading I have to make then as single record and then load into Table.
Any help is much appreciated.