Search notes:

Oracle pseudo column ROWNUM

rownum is a pseudo column that assigns a row number, starting with 1 and increasing by 1, to each record returned from a select statement.

See also

Compare with

the row_number() SQL function and
the row limiting clause of select statements.

The plan operation COUNT.

rownum is frequenty used to limit the number or returned records, see generate date with SQL.