title: SELECT ALL... in Oracle SQL
body: <p>I was researching packages from DB, when I saw following query:</p>
  
  <pre><code>SELECT ALL TABLE1.CODE, nvl(TABLE1.EXPLANATION, '') as Explanation 
  FROM TABLE1;
  </code></pre>
  
  <p>I couldn't find what is the usage of <code>ALL</code> in <code>SELECT</code> statement, I know that using <code>ALL</code> in <code>WHERE</code> has meaning of <code>AND</code>.</p>
  
  <p>Could you please clear this out for me?</p>