title: Regex to replace TO_DATE in string
body: <p>I have a string that has a TO_DATE function in it. I would like to replace this TO_DATE call with SYSDATE.</p>
  
  <p>For example, my string is basically a SQL insert or update, so I have something like</p>
  
  <pre><code>INSERT INTO table_a (col_a, col_b, col_c, updt_dt) VALUES ('A', 'B', 'C', to_date('2012-06-11 22:10:44', 'YYYY-MM-DD HH24:MI:SS'));
  </code></pre>
  
  <p>And I want to replace the TO_DATE call with this:</p>
  
  <pre><code>INSERT INTO table_a (col_a, col_b, col_c, updt_dt) VALUES ('A', 'B', 'C', SYSDATE);
  </code></pre>
  
  <p>Remember, this entire insert statement is in one database field. So, how could I use <code>regexp_replace</code> to replace the TO_DATE call with SYSDATE? </p>
  
  <p>I am running Oracle 10gR2.</p>