title: Oracle : removing certain characters from string
body: <p>We have to remove certain characters from VARCHAR2 and CLOB data types using SQL or PL/SQL and load into destination tables.</p>
  <p>There are functions available in Oracle ( e.g REGEXP_REPLACE or SUBSTR ) which can be used.</p>
  <p>However, we have large amount of data.</p>
  <p>Will it be faster if we extract the data into Linux host and use a combination of TR ( /bin/tr ) and Oracle External Files ?</p>