The select statement used in this example is:
select dept.deptnoThe CSS used in that statement is defined by:One remark: You should disable sorting, filtering etc. on the "enames" column, because that makes no sense...
' ' enames
, ( select deptno, listagg( ename, ', ') within group (order by sal) enames
group by deptno
where emps.deptno (+) = dept.deptno
Edit: Thanks to Alex (see comments) the solution can be changed to something more elegant:
Just select the ENAMES column, and set these properties
- Link Text = <img src="#IMAGE_PREFIX#apps_info.gif" alt=""></a><div class="overlay" id="#DEPTNO#" style="display:none">#ENAMES#</div>
So the SQL is "clean" now and you even can enable the sorting etc again!