Untitled

create table test_swift
(id number ,
block4 clob
);

insert into test_swift
values
(123,
'<batch><msg_subtype>102</msg_subtype>
 <body>:1:555
 :2:SENDER
 :3:11
 :4:INR75,00
 :5:/AC1
 :6:RECEIVER
 :7:/AC2
 :8:/DNUM/01
 /DDATE/140702
 :3:22
 :4:INR700,00
 :5:/Acc3
 :6:RECEIVER
 :7:/Acc4
 :8:/DNUM/02
 /DDATE/140702
 :9:140702INR775,00
 :10:/NUM/5
 /PRT/20</body><sign></sign></batch>'
 );
 commit;

create table test_line
(
t1 varchar2(10),
t2 varchar2(10),
t3 varchar2(20),
t4 varchar2 (20),
t5 varchar2(10),
t6 varchar2(10),
t7 varchar2(20),
t8 varchar2(20),
t9 varchar2(50),
t10 varchar2(50)
);
T1     T2       T3    T4         T5    T6         T7     T8       T9        T10
555    SENDER   22    INR700,00  Acc3  RECEIVER   Acc4   /DNUM/02/DDATE/140  140702INR775,00   /NUM/5/PRT/20
555    SENDER   11    INR75,00   AC1   RECEIVER   AC2    /DNUM/01/DDATE/140  140702INR775,00   /NUM/5/PRT/20