title: Java Regex find/replace pattern in SQL comments
body: <p>I want to find/replace a character/pattern ONLY inside SQL comments ( single line comments -- and block comments /* */).   The source string is an SQL script.</p>
  
  <p>At the moment I am searching for a semi-colon (;) within comments and want to replace it with blank space.</p>
  
  <p>Source</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE TESTDBA.PROC_REUSING_BINDED_VAR_N_DSQL
  
   AS
          a NUMBER:=2;
          b NUMBER:=3; -- jladjfljaf; lakjflajf
  -- alksdjflkjaf ladkjf 
          v_plsql_tx VARCHAR2(2000);
      begin
          v_plsql_tx := 'BEGIN ' || ' :1 := :1 + :2; ' || 'END;';
          execute immediate v_plsql_tx
          using in out a, b;
          insert into testdba.NEW_TESTING_TABLE(CHARACTER_VALUE) VALUES('a='||a);
     end PROC_REUSING_BINDED_VAR_N_DSQL;
  -- lajdflajf
  
  /*lakjdfljalfdk; alkdjf*/
  
  /*asdf 
  ;
  asdfa*/
  
  /*
      adf
  asd asdf
  
  
  */
  </code></pre>
  
  <p>Can you please suggest something.</p>
  
  <p>Thanks</p>