Hi All,
I have a XMLTYPE column in source table with rowset and row tags. Updating this column data to another clob column of another column adds another set of rowset and row tags and results in 2 sets of rowsets and row tags. Is there any way... we can avoid addition of the 2nd set. Please help
<?xml version="1.0"?>
<ROWSET>
<ROW>
<XML_DATA>
<ROWSET>
<ROW>
<XML_DATA>
</XML_DATA>
</ROW>
</ROWSET>
</XML_DATA>
</ROW>
</ROWSET>