title: delete records older than 24 hours in oracle SQL
body: <p>I want to delete all the records which is older than 24 hours. I am using the below query for the same but sometimes doesn't run perfectly. I want to know whether my query is right or wrong ? Or which is better way to do so.</p>
  
  <pre><code>delete from TEMP_SERVICE_OPTION where EVENT_DATE &lt; TRUNC(SYSDATE) - 1;
  </code></pre>