How Can I Select All Columns and ROWNUM in Oracle Without Explicitly Listing Columns?

Selecting Columns and ROWNUM Simultaneously

In Oracle, SELECT statements can retrieve the row number as a column alongside other data. However, specifying each column manually can be tedious. This article explores a solution to retrieve all columns plus ROWNUM without explicit column listing.

Problem Statement

You want to select all rows and columns from a table, including an additional column for row numbering. Traditionally, this requires explicitly listing each column:

SELECT rownum, column1, column2 FROM table

However, you wish to avoid naming each column and instead use a wildcard.

Solution

You can qualify the wildcard (*) with the table name to achieve the desired result:

SELECT rownum, table.* FROM table

This syntax informs Oracle to retrieve all columns from the specified table, effectively replacing the explicit column listing:

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

The above is the detailed content of How Can I Select All Columns and ROWNUM in Oracle Without Explicitly Listing Columns?. For more information, please follow other related articles on the PHP Chinese website!