title: ORA-01797: this operator must be followed by ANY or ALL error
body: <p>While I am executing the query,</p>
  
  <pre><code>select *
  from file_log f
  where F.DCP_SRCE_FILENM_FK in ('ABC','DEF') and
        F.TRANS_DT&gt;=to_date('08/25/2017','mm/dd/yyyy') and
        F.TRANS_DT&lt;=('08/30/2017','mm/dd/yyyy')
  </code></pre>
  
  <p>am getting the following error:</p>
  
  <blockquote>
    <p>ORA-01797: this operator must be followed by ANY or ALL.</p>
  </blockquote>
  
  <p>Could you all please help me in writing the proper query so that this error would go?</p>