Skip to Main Content

SQL & PL/SQL

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!

(Resolved)Need help to combine column result into one in sql

omkSep 14 2019 — edited Sep 24 2019

Hi everyone,

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

This post has been answered by mathguy on Sep 23 2019
Jump to Answer
Comments
Post Details
Added on Sep 14 2019
18 comments
2,884 views