2 Replies Latest reply: Aug 3, 2012 3:40 PM by Georgey RSS

    Remove/Replace some data in CLOB

    Georgey
      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