Clarity

 View Only
Expand all | Collapse all

Putting values from same column in one cell, grouped by Res (Oracle query)

  • 1.  Putting values from same column in one cell, grouped by Res (Oracle query)

    Posted Apr 03, 2019 10:58 AM

    Hi everyone, 

    I'm trying to build a portlet to show the right groups that each resource has. The problem I'm experiencing is that each group is shown in different cells(on different rows), so if the resource has let's say, 4 groups, then the same resource will be shown in 4 rows, mentioning one group in each row.

    I managed to put the groups all together in one row separated by " / " using Stuff function on SQL Server, but can't find a way to do so on Oracle.

     

    Any help will be really appreciated

    Cheers!

     

    Francisco



  • 2.  Re: Putting values from same column in one cell, grouped by Res (Oracle query)

    Broadcom Employee
    Posted Apr 03, 2019 02:38 PM

    Hi Francisco - 

     

    I believe using LISTAGG in Oracle 11.2 would work.

    LISTAGG 

     

    Please let me know if this helps!

     

    -Stephanie