title: Oracle - return multiple counts as one query
body: <p>I have a couple of queries, detailed below. I'd like to be able to run one SQL query which returns both counts, is this possible?</p>
  
  <p>1.</p>
  
  <pre><code>select nvl(count(rowid), 0) from tablename where OPP = 'FOO' and date = 'BAZ';
  </code></pre>
  
  <p>2.</p>
  
  <pre><code>select nvl(count(rowid), 0) from tablename where OPP = 'BAR' and date = 'BAZ';
  </code></pre>
  
  <p>I've only found MSSQL specific solutions in my searches so far.</p>