title: How to select all columns, and a count(*) in the same query
body: <p>In often use in TSQL the following query : </p>
  
  <pre><code>SELECT COUNT(*), * 
  FROM CUSTOMER c 
  WHERE c.Name like 'foo%';
  </code></pre>
  
  <p>When I try to execute this query in Oracle SQL Developer it doesn't work and throws me an error:</p>
  
  <blockquote>
    <p>"Missing expression"</p>
  </blockquote>
  
  <p>What is the good syntax ?</p>
  
  <p>Thanks in advance.</p>