title: REGEXP_REPLACE to remove list of words from company name column
body: <pre><code>select 'Owens 1245 Coning COM CO LTD INC CORP INC', REGEXP_REPLACE(
        UPPER(TRIM(REGEXP_REPLACE(TRIM(REGEXP_REPLACE(regexp_replace('Owens 1245 Coning COM CO LTD', '(*[[:punct:]])', ' '),'(\s[0-9]+\s)|(^[0-9]+\s)|(\s[0-9]+$)',' ')),'( ){2,}', ' '))), 
        '\\b'||'CO|LTD|INC|CORP'||'\\W'
        ,'') CLEARTEXT
  from dual;  
  </code></pre>
  
  <p>if i run the above query it removes all the stop words except "CO" and gives the output : OWENS CONING COM CO </p>
  
  <p>however i need the output to be like : OWENS CONING COM</p>