title: Oracle SQL Case statement with NULL values
body: <p>I'm trying to create an Oracle query that will use a parameter based on the <code>CommandName</code> of a button.</p>
  
  <p>So here's my query</p>
  
  <pre><code>SELECT id 
  FROM table 
  WHERE dateTime IS (CASE WHEN :CommandName = 'FIRST' THEN NULL ELSE NOT NULL END)
  </code></pre>
  
  <p>So I'm passing the parameter but it's not working - I'm just getting a <code>Missing NULL keyword</code> error</p>
  
  <p>I basically don't want to have to write two separate queries based on the parameter that is input</p>
  
  <p>Not even sure if this is possible or if this is the right way of doing it?</p>
  
  <p>Any ideas?</p>