title: Can we have multiple "WITH AS" in single sql - Oracle SQL
body: <p>I had a very simple question: Does oracle allow multiple "WITH AS" in a single sql statement.</p>
  
  <p>Example:</p>
  
  <pre><code>WITH abc AS( select ......)
  
  WITH XYZ AS(select ....) /*This one uses "abc" multiple times*/
  
  Select ....   /*using XYZ multiple times*/
  </code></pre>
  
  <p>I can make the query work by repeating the same query multiple times, but do not want to do that, and leverage "WITH AS".
  It seems like a simple requirement but oracle does not allow me:</p>
  
  <blockquote>
    <p>ORA-00928: missing SELECT keyword</p>
  </blockquote>