Need help to combine column result into one in sql

  • susan

    SSC Rookie

    Points: 32

    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

  • rVadim

    Hall of Fame

    Points: 3922

    You do realize that this is not an Oracle forum, right? Simple Google search for Oracle forums should get you to the right place, for example:

    https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_and_pl_sql

    --Vadim R.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply