sql loader load multi-lines into one column
733391Mar 15 2010 — edited Mar 18 2010I got a txt file, which is like:
the first record : |111|,,|aaa|bbb|,||,12/01/2009,||
the second record : |222|,|xx|,|ccccwwww|,||,12/02/2009,|PA|
the third record : |333|,|yy|,|abcd
2345 9989098099899 asasjkhsjkd
yoyiyoi : yyyyy
jjjjjjjjj|,
11/30/2009,|NY|
The field is terminated by ",", and is enclosed by "|".
I am trying to use SQL loader to load into oracle database.
The issue for me is
1. the Vertical bar(|, pipe)
2. multi-lines should be in one column.
ANy suggestion for the control file?
Thanks!
Edited by: user1665291 on Mar 15, 2010 11:55 AM