1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

wm_concat

Discussion in 'SQL PL/SQL' started by abhi, Dec 12, 2011.

  1. abhi

    abhi Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    85
    can anyone explain me about wm_concat in oracle
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    It's a previously undocumented function (documented in 10gR2, if I remember correctly) which concatenates values in column and separates the values with commas. It's used with group by to create comma-delimited lists of values based upon a group by 'key'. 11gR2 implements listagg, a similar but far more versatile function, to perform the same function.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India