Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to concat two or more xml

User_RFKSXMay 25 2020 — edited May 27 2020

hi,

I have a table like MYTABLE   (doc   xmltype)

I have to write a pl sql where I want to concat two xmltype element and insert the result in the table

declare

ONE        xmltype;

TWO        xmltype;

RES        xmltype;

begin

select xmlelement(....

        xmlelement(...

        xmlelement(...

        into ONE

        from ;

 

select xmlelement(....

        xmlelement(...

        into TWO

        from ;

       

  -- how can I concat ONE and TWO into RES ?

 

  insert into MYTABLE values (RES);

end;

/

thanks in advance!

Mark

This post has been answered by Paulzip on May 26 2020
Jump to Answer
Comments
Post Details
Added on May 25 2020
6 comments
2,208 views