How to add a new line after a column in sql query Oracle Apex

Question

I'm running the following sql query in my Oracle Apex application:

SELECT column1 || chr(13) || chr(10) || column2 FROM table;

I want the second column to be displayed on a new line. This doesn't seems to be working in my Apex application. However it's working on SQL*PLUS.

Any ideas what could be the problem here and how can I fix it?

Answer 1

What you can do is change the display type of the the column to "Standard Report Column" and change your query to

SELECT column 1 || '<br/>' || column2 FROM table;

However, you'll have to be sure that your data won't contain valid HTML or characters, because things like > would convert to >