title: how to define multiple (WITH AS FUNCTIONS) in a single query?
body: <p>trying to  define multiple functions under a single with clause. which we normally do for CTE's. But for functions the same is not working. Please suggest solutions please. </p>
  
  <pre><code>With function dt ( b as number) 
  return number is 
  n number ; 
  begin 
  select  1 into n; 
  return n ; 
  end ; 
  dt2 ( c as number) 
  return number is 
  n1 number ; 
  begin 
  select  1 into n; 
  return n1; 
  end ; 
  
  select dt(1) , dt2(1) from dual 
  </code></pre>
  
  <p>when using only dt i am able to get o/p but not with dt2.</p>