Rows To Columns--urgent!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • napstar
    New Member
    • Nov 2006
    • 55

    Rows To Columns--urgent!!

    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
  • Saii
    Recognized Expert New Member
    • Apr 2007
    • 145

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

    Comment

    Working...