This discussion is archived
2 Replies Latest reply: Aug 3, 2012 1:40 PM by Georgey RSS

Remove/Replace some data in CLOB

Georgey Newbie
Currently Being Moderated
Hello
I have a CLOB column in one of my tables (Table1), which stores very large (150MB+) XML files. I have new/another table (Table2) in the DB where I have an XMLType column. I want to take the CLOB data (xml) from table1 and remove some part of that and store the rest into to the XMLType column of Table2.

I want to remove the data inside the XML tags
<Attachments>
very long data goes here... which I dont need, which should be replaced with a single word
</Attachments>

store the CLOB to XMLType column after removing the unwanted data.

Warm Regards
-Georgey

Edited by: Georgey on Aug 3, 2012 12:07 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points