Auto id for select statements in Oracle

Question

Is it possible to create / to have an auto id column in the select statements in Oracle.

Example: Assume we have a table ITEMS without an id

Normal select-statement

Select name
from ITEMS

What I'm looking for is something like this

select AutoIdGen(), name
from ITEMS

Answer 1

You can use ROWID or ROWNUM in oracle ,like this:

SELECT ROWID,ROWNUM,name from ITEMS;