I am currently running in pl/sql developer and Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 .
I need to combine the result into one . Now I get all the result that i want by using the select statement show (show below)
ISSUE ID author created comment
123 sa 2019/02/01 clob
123 aby 2019/08/01 clob
123 wayne 2019/08/10 clob
But my goal is to achieve the result below , making all result turn into one line :
123 sa 2019/02/01 clob , aby 2019/08/01 clob , wayne 2019/08/10 clob
Is there any one can help to bring out this result in pl/sql ?
Thank you so much