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!

what is xmlagg xmlelement

Discussion in 'SQL PL/SQL' started by sandip.senmajumder, Feb 4, 2011.

  1. sandip.senmajumder

    sandip.senmajumder Active Member

    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    80
    Hi all......
    any one of explain what is (xmlagg(xmlelement(e,QualifyingExamid,',').extract('//text()')),',')........
    and how to deal with it.


    thanks
    sandip
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: xmlagg

    That aggregates the extracted XML elements into a comma-separated list. Why do you have to 'deal with it'?
     
  3. sandip.senmajumder

    sandip.senmajumder Active Member

    Messages:
    27
    Likes Received:
    0
    Trophy Points:
    80
    i need to send a , separated string to the caller over the program_id's
     
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    XMLELEMENT will take an element name for identifier and returns an instance of type XMLType.

    While XMLAGG takes a collection of XML fragments and returns an aggregated XML document.

    These can be used to from a string as mentioned by you.