I have a txt which contain data for multiple table which delimeter as " § "
I have a bit of confusion to insert the record into multiple table can anyone help me to sort this problem and post me how to write control file for this scenario.
The given may change or the tables may not contain the data.
Header
1§00§Table_1§
1§50§E1§Ashok§27§Male§
1§50§E2§Asha§29§Female§
1§50§E3§Ramya§25§Female§
1§50§E4§Maha§25§Female§
1§99§48§
1§00§Table_2§
1§50§E1§IT§PE§
1§50§E2§IT§TT§
1§50§E3§IT§TL§
1§50§E4§IT§PM§
1§99§48§
1§00§Table_3§
1§99§0§
[Updated on: Sun, 29 March 2009 04:28]
Report message to a moderator