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

    Remove/Replace some data in CLOB

      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
      very long data goes here... which I dont need, which should be replaced with a single word

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

      Warm Regards

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