2 Replies Latest reply: Jan 24, 2013 11:26 PM by Ava RSS

    How to Use LISTAGG function @ OWB 11.2.0.3 (11gR2)

    Ava
      Hi,

      I would like to create mapping using LISTAGG function at OWB - 11.2.0.3 (Version).

      Could you please suggest in which operator (LISTAGG(ENAME, '; ') WITHIN GROUP (ORDER BY DEPTNO)) i can write below statement.

      SELECT DEPTNO,
      LISTAGG(ENAME, '; ') WITHIN GROUP (ORDER BY DEPTNO) AS ENAME
      FROM SCOTT.EMP
      GROUP BY DEPTNO

      Regards,
      Ava