title: Oracle date difference with case
body: <p>I have the following:</p>
  
  <pre><code> select nvl ( 
       (select 1
        from tableA, tableB 
        where tableA.id(+) = 9999
        and tableB.project_id(+) = tableA.project_id
        and sysdate - tableA.start_date &lt; 120), 0) as myFlag from dual;
  </code></pre>
  
  <p>I am trying to see if the project start date is less than 120 or not. The above query works but is there a better way of doing this? Like with a  case statement?</p>