Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple lines text needed as input and output

573381Apr 26 2007 — edited Apr 26 2007
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 24 2007
Added on Apr 26 2007
3 comments
589 views