Skip to Main Content

APEX

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!

Interactive Report does not display LISTAGG SQL data correctly although it is displayed correctly in the database table.

user6757733Apr 8 2024

I have an interactive report. One column in the database table that the report pulls data from, has the data stored using LISTAGG and using char(10), which is carriage return, to separate the data so that ii appears over multiple lines for readability. However in the interactive report the data is displayed in one continuous line of data and not on separate lines. Any ideas as to how to fix this?

This post has been answered by jariola on Apr 8 2024
Jump to Answer
Comments
Post Details
Added on Apr 8 2024
2 comments
481 views