How do I select all the columns from a table, plus additional columns like ROWNUM?

Question

Hey guys, I'm sure this is an easy question, but I have looked around and haven't found a way to do it. In Oracle, I know it's possible to do a select statement that returns the row number as a column in your result set. Example:

select rownum, column1, column2 from table

Returns:

rownum       column1       column2
1            Joe           Smith
2            Bob           Jones

But I don't want to specify each column by hand. I want to do something like:

select rownum,* from table

rownum       column1       column2       column3       column4
1            Joe           Smith         1             2
2            Bob           Jones         3             4

Any ideas? Thanks!

Answer 1

Qualify the * with the name of the table:

select rownum, table.* from table

Answer 2

Have you tried ROW_NUMBER() ?

Answer 3

What's the deal with the row numbers? Sounds like you need an incrementing primary key, often named 'id'