Skip to Main Content

Database Software

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!

Updating xmltype column with existing rowset and row tags from 1 table to another table

user8195117Jul 17 2020 — edited Jul 23 2020

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>

This post has been answered by user8195117 on Jul 23 2020
Jump to Answer

Comments

Post Details

Added on Jul 17 2020
5 comments
418 views