title: Can we write for loop in HPQC/ALM Query builder
body: <p>I am using HPQC/ALM version 11.00 and I want to write an sql statement that retrieve the number of step that passed, failed, blocked, etc... for each run id.</p>
  
  <p>I tried to write a for loop, but query builder throws 'Quality Center cannot run the query because it contains invalid statement'</p>
  
  <pre><code>select runids in (select rn_run_id from run)
  loop
  select r.rn_run_id from run r where r.rn_run_id = runids.rn.run_id
  end loop;
  </code></pre>
  
  <p>db type = oracle</p>