title: How does 'in' clause works in oracle
body: <pre><code>select 'true' from dual where 1 not in (null,1);
  </code></pre>
  
  <p>when we execute this which will result nothing</p>
  
  <p>what my question is:</p>
  
  <p>is the above query is logically equivalent to </p>
  
  <pre><code>select 'true' from dual where 1 != null and 1 != 1;
  </code></pre>
  
  <p>which will result nothing just as above statement</p>
  
  <p>Please clarify?</p>