title: Number of rows in Oracle SQL Select?
body: <p>I need to know how many records were returned in a select in oracle.  Currently, I do two queries:</p>
  
  <pre><code>SELECT COUNT(ITEM_ID) FROM MY_ITEMS;
  
  SELECT * FROM MY_ITEMS;
  </code></pre>
  
  <p>I need to know the COUNT but I hate doing two queries.  Is there a way to do:</p>
  
  <pre><code>SELECT * FROM MY_ITEMS 
  </code></pre>
  
  <p>and then find out how many records are in there?</p>