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!

Is it possible to add a newline to a column?

25631Jul 17 2011 — edited Jul 21 2011
Hi,

So I am wondering if it is possible to add a newline to a column in a SQL report? For example I have 4 columns I am selecting. I want the first two columns to be on one line then have a <br> then the next two columns
to be on the next line. Is something like this possible?
I have tried things like
select column1, column2, '<br/>' || column3, column4
but that doesnt seem to work.

Any help would be appreciated

Thanks in advance!

Edited by: goochable on Jul 17, 2011 8:38 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2011
Added on Jul 17 2011
28 comments
1,237 views