title: Preserve Special Charcters While Migrating Data
body: <p>I am using the below code to extract data from source legacy database and putting into a CLOB column in target 11g database</p>
  
  <pre><code>RTRIM (  
              XMLAGG (XMLELEMENT (  
                         e,  
                         REPLACE (  
                            REGEXP_REPLACE (  
                               REPLACE (prod_desc, CHR (10), '~~~'),  
                               '[[:cntrl:]]'),  
                            '~~~',  
                            CHR (10)),  
                         CHR (10)) ORDER BY prod_date DESC).EXTRACT ('//text()').getclobval (),  
              CHR (10))  
  </code></pre>
  
  <p>prod_desc column has '&lt;' , '>' '&amp;' and other special characters, these are getting replaced with <code>&amp;lt;</code> <code>&amp;gt;</code> , <code>&amp;amp;</code>  respectively.</p>
  
  <p>How can I preserve the above values even I migrate the data from source to target?</p>
  
  <p>Thanks</p>