Skip to Main Content
Forums

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!

SQL Query to fetch Multi-line within colulmn for a defined length

IstanbulAug 13 2015 — edited Aug 14 2015

Hi All,

It would be helpful if you provide your suggestions to achieve the below.

I have a column in a table which usually contains multi line data as given below,

SQL_1.JPG

The output of the query will look like,

SQL_2.JPG

The purpose is to convert the column to rows with each row not exceeding 20 characters and the last character needs to be the end of the line.
Sample output below,

SQL_3.JPG

Thanks in Advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2015
Added on Aug 13 2015
11 comments
2,188 views