Analytics Software

Hi,

Sorry i forgot my Oracle version :

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for 64-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

I searched in google but i didn't found the solution.


I looking for a function in discoverer equivalent to stragg sql function.


Note : stragg function convert columns to rows.

Thanks

SELECT   deptno, stragg ('-' || ename)
    FROM emp_test
GROUP BY deptno;


    DEPTNO STRAGG_STR                                                  
---------- ------------------------------------------------------------
        10 -CLARK-KING-MILLER                                          
        20 -SMITH-FORD-ADAMS-SCOTT-JONES                               
        30 -ALLEN-BLAKE-MARTIN-TURNER-JAMES-WARD                       


3 rows selected.

Edited by: Salim Chelabi on 2010-01-29 08:32