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
Hi Francisco -
I believe using LISTAGG in Oracle 11.2 would work.
Please let me know if this helps!