title: Oracle: '= ANY()' vs. 'IN ()'
body: <p>I just stumbled upon something in ORACLE SQL (not sure if it's in others), that I am curious about. I am asking here as a wiki, since it's hard to try to search symbols in google... </p>
  
  <p>I just found that when checking a value against a set of values you can do </p>
  
  <pre><code>WHERE x = ANY (a, b, c)
  </code></pre>
  
  <p>As opposed to the usual </p>
  
  <pre><code>WHERE x IN (a, b, c)
  </code></pre>
  
  <p>So I'm curious, what is the reasoning for these two syntaxes? Is one <strong>standard</strong> and one some oddball Oracle syntax? Or are they both standard? And is there a preference of one over the other for performance reasons, or ? </p>
  
  <p>Just curious what anyone can tell me about that '= ANY' syntax. 
  CheerZ!</p>