hi Mr.chandra...

thankx for the reply. how can i accomplish the same thing using sqlloader.
if u find time kindly give the solution also with all possible ways


swetha