This content has been marked as final. Show 2 replies
Column datatype is XMLTYPE, right? Then:
UPDATE your_table_name SET your_column_name = DELETEXML(your_column_name,'path-to-node-Attachments');
Thanks for the response.
The XML is currently in a CLOB column, I want to remove the Attachments and put them to an XMLType column.