title: Case Statement on Multiple conditions in Oracle
body: <pre><code>CASE test
  WHEN  NULL and  SUBSTR(('99999999' - Tst_Date),1,4) &gt; 2009 THEN 'Medi'                     
  WHEN   NULL and SUBSTR(('99999999' - Tst_Date),1,4) &lt; 2009 THEN 'hills'
  ELSE test
  END AS "Phy"
  </code></pre>
  
  <p>Am i missing something in the above case statement?
  I keep on getting 00905. 00000 -  "missing keyword" error?</p>