title: Using COUNT(*) and INTO oracle sql
body: <p>I have select statement like this:</p>
  
  <pre><code>    with input as
      (select id,date,quantity
      from
      abc a,xyz z
      .......)
           select count(*)
           from input t
           where .....;
  </code></pre>
  
  <p>this statement gives me a result of 0 and i want to use this count=0  my part of procedure . I added select count(*) output from which looks like this now:</p>
  
  <pre><code> select count(*) output
   with input as
      (select id,date,quantity
      from
      abc a,xyz z
      .......)
           select count(*)
           from input t
           where .....);
  </code></pre>
  
  <p>now the output will not be 0(zero) anymore because it counts the result of zero itself and give the final result as 1..how can i use INTO statment to pass/hold that zero or any other real result in ORACLE/SQL?</p>