I have a below file.
INPUT FILE
select * from customer
MERGE INTO Archive; delete from Employee; using select * from customer;
delete from employee; select * from Employee;
insert into employee(1,1);
OUTPUT FILE
select * from customer
MERGE INTO Archive
delete from Employee
using select * from customer
delete from employee
select * from Employee
insert into employee(1,1)
I want to split the line from deimeter semicolun `;`
& each statement in single line.
It might be happen that Semicolon is not comming in line or not comming.
I try this with CUT command but it will work only on single line.