AnsweredAssumed Answered

Inserting new line characters into query results?

Question asked by StevenJames on Jul 12, 2011
Latest reply on Jul 19, 2011 by another_martink
Hello all,
This is my first post, so please be gentle...
Firstly, a big thank you to all the contributors to this message board. It has been a valuable resource to me over the last few weeks whilst I have been tackling my first Clarity development tasks.
Using some good examples from here, I have successfully merged multiple records into a single field to display on a grid portlet with NSQL using the SYS_CONNECT_BY_PATH function and delimited the records with, for example, a comma.
However, what I would like to achieve is each record to start on a new line within the field rather than being delimited by a character.
So what I have tried so far is the wrap the SYS_CONNECT_BY_PATH function with the REPLACE function to replace the delimiter with chr(13) and chr(10) e.g.
REPLACE(SUBSTR(SYS_CONNECT_BY_PATH(CODE, ', '), 2),',',chr(13)||chr(10))
This doesn't appear to work when the portlet displays the data, the records remain on the same line. Has anybody else had any success splitting data onto multiple lines?