How to load multiple lines in one record?
Posted on 2015-02-12
create table T(
C1 number ,
C3 varchar2(50) ) ;
Want to load the data below. For example, 2 records:
/ccccccccccccccccccccc/dddddd,^|^This is a test^|
20|^'/ffffffffffffffffffffffffffff/gggggggggggggggg', /hhhhhhhhhhhhhhhhhhhhhhhhhhh/gggggggggg /jjjjjjjjjj/
rrrrrrrrrrrr/sssssssssssss/tttttttt^|^The one is also a test^|
... many lines
The data is delimited by | and optionally by ^. The multiple variable lines in one record need to be loaded into column C2. How to write the control file if I want to load the data into T? Can the format be kept?