title: How do I select all the columns from a table, plus additional columns like ROWNUM?
body: <p>In Oracle, it's possible to do a <code>SELECT</code> statement that returns the row number as a column in your result set.</p>
  
  <p>For example,</p>
  
  <pre><code>SELECT rownum, column1, column2 FROM table
  </code></pre>
  
  <p>returns:</p>
  
  <pre>
  <b>rownum</b>       <b>column1</b>       <b>column2</b>
  1            Joe           Smith
  2            Bob           Jones
  </pre>
  
  <p>But I don't want to specify each column by hand. I want to do something like:</p>
  
  <pre><code>select rownum,* from table
  </code></pre>
  
  <pre>
  <b>rownum</b>       <b>column1</b>       <b>column2</b>       <b>column3</b>       <b>column4</b>
  1            Joe           Smith         1             2
  2            Bob           Jones         3             4
  </pre>
  
  <p>Any ideas?</p>