title: Oracle trigger efficiency vs scheduled jobs
body: <p>Certain invalid characters sometimes get inserted into database due to improper keyboard configuration of end-users.</p>
  
  <p>We have a pl/sql script that iterates through all columns and replaces the invalid characters. The script takes less than one minute to complete (but our system is still beta and is not used widely) .</p>
  
  <p>One solution is to create a trigger that replaces the invalid characters right before insertion into the tables and one solution would be using a scheduled job to run the so-called script.</p>
  
  <p>Which one is more efficient ?</p>