title: Passing a parameter to a WITH clause query in Oracle
body: <p>I'm wondering if it's possible to pass one or more parameters to a WITH clause query; in a very simple way, doing something like this (taht, obviously, is not working!):</p>
  
  <pre><code>with qq(a) as (
    select a+1 as increment 
      from dual
  )
  select qq.increment 
    from qq(10); -- should get 11
  </code></pre>
  
  <p>Of course, the use I'm going to do is much more complicated, since the with clause should be in a subquery, and the parameter I'd pass are values taken from the main query....details upon request... ;-)</p>
  
  <p>Thanks for any hint</p>