I have a function that returns an associative array:
SELECT * FROM table(FUN_SUBCS RIBERTEMP_RPT_B OP(2004)) which gives the following output:
I DATERAN
---------------------- -------------------------
0 31-JAN-04
29671 29-FEB-04
30002 31-MAR-04
30306 30-APR-04
30612 31-MAY-04
How can transform above output into this?:
DATERAN 31-Jan-04 29-Feb-04 31-Mar-04 30-Apr-04 31-May-04
I 0 29671 30002 30306 30612
SELECT * FROM table(FUN_SUBCS RIBERTEMP_RPT_B OP(2004)) which gives the following output:
I DATERAN
---------------------- -------------------------
0 31-JAN-04
29671 29-FEB-04
30002 31-MAR-04
30306 30-APR-04
30612 31-MAY-04
How can transform above output into this?:
DATERAN 31-Jan-04 29-Feb-04 31-Mar-04 30-Apr-04 31-May-04
I 0 29671 30002 30306 30612
Comment