title: create a view for multiple queries in Oracle
body: <p>I have 4 SQL queries that fetch data from the same table and I was wondering whether you can create a view containing multiple queries. For instance, one of these queries looks something like: </p>
  
  <pre><code>SELECT Count(COLUMN1) FROM TABLE1 WHERE COLUMN3 &gt; '01-Oct-12' AND COLUMN3&lt; '01-Nov-12' 
  </code></pre>
  
  <p>whereas another looks like: </p>
  
  <pre><code>SELECT Count(COLUMN2) FROM TABLE1 WHERE COLUMN3 &gt; '01-Oct-12' AND COLUMN3 &lt; '01-Nov-12' 
  </code></pre>
  
  <p>Thanks,</p>
  
  <p>I. </p>