Need help to combine column result into one in sql

• susan

  SSC Rookie

  Points: 32

  More actions

  September 13, 2019 at 9:38 pm

  #3679994

  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: 3969

  More actions

  September 13, 2019 at 9:46 pm

  #3679995

  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.