Add element into XML using PL/SQL
879879Jul 12 2012 — edited Jul 13 2012I have CLOB column contain XML data(more than 3000 character)
something like this
--------------------------------------------------------------
<order>
<header>
<line1></line1>
<line2>
<name1></name2>
<name1></name2>
</line2>
</header>
<detail>
</detail>
</order>
----------------------------------------------------------------
Could anyone tell me how can I add an *<line3></line3>* under an element *<header>*.
Thank you!
Fah