Multiple lines text needed as input and output
573381Apr 26 2007 — edited Apr 26 2007Hi all,
I want to enter the string in a table and i want to see that text as multiple lines
in a report.So when i'm entering text i'm giving '\' for newline seperation rather to press enter butoon as like in notepad etc.
after entering the text i'm using this query for making the text into multiple lines.
Plz see the below query.It is not giving the entire string in multiple lines.
select replace('aaaa\bbb\ccc\ddd\eee\fff\ggg\hhh\kkk','\',chr(10)) from dual;
In Reports 6i,
Any idea of taking the text as input parameter in multiple lines and priting it in multiple lines .
or any new ideas?
Plz suggest me.
Thank you.
Regards,
Basava.S