Hi,
Lets take i have table like below.
create table detail_ssi(currency varchar2(10),details varchar2(4000));
now user is going to insert as below(From application)
insert into detail_ssi('USD','hello ds is venky ,working with OFSS ,getting salary to citi bank's account ');
Now my requirement is "hello ds is venky ,working with OFSS ,getting salary to citi bank's account" string should not be inserted as a single line.it should be look like as below with multiple lines.
select * from detail_ssi
-----------------------------------
USD hello ds is venky ,
working with OFSS ,
getting salary to citi bank's account
Note: If we manually insert multiple lines then requirement would be solved but i wanted if we have insert long string then automatically it should split into multiple lines based any criteria (In my Example it can be ','(comma))
How can i achieve above requirement either using SQl/PLSQL ?
Regards
Venky