ROW ID
1. Physical address of the rows.
2. Rowid is permanent
3. Rowid is 16-bit hexadecimal
4. Rowid gives address of rows or records
5. Rowid is automatically generated unique id of a row and
it
is generated at the time of
insertion of row.
6. ROWID is the fastest means of accessing data.
7. They are unique identifiers for the any row in a table
ROWNUM:
1. Rownum is the sequential number, allocated to each
returned row
during query execution.
2. Rownum is temporary.
3.Rownum is numeric
4.Rownum gives count of records
5. Rownum is an dynamic value automatically
retrieved along with select statement output.
6. It represents the sequential order in which Oracle has
retrieved the row