Connecting Tech Pros Worldwide Forums | Help | Site Map

Rows To Columns--urgent!!

Member
 
Join Date: Nov 2006
Posts: 44
#1: Apr 28 '09
I have a function that returns an associative array:
SELECT * FROM table(FUN_SUBCSRIBERTEMP_RPT_BOP(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

Saii's Avatar
Expert
 
Join Date: Apr 2007
Posts: 141
#2: Apr 30 '09

re: Rows To Columns--urgent!!


You can create a user defined aggregate function to concat the values. Search for ODCIAggregate
Reply