Case Statement on Multiple conditions in Oracle
<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>