Tuesday, December 18, 2012

Differences between rowid and rownum


Scenario:
Differences between rowid and rownum

Solution:

Rowid
Rownum
Rowid is an oracle internal id that is allocated every time a new record is inserted in a table. This ID is unique and cannot be changed by the user.
Rownum is a row number returned by a select statement.
Rowid is permanent.
Rownum is temporary.
Rowid is a globally unique identifier for a row in a database. It is created at the time the row is inserted into the table, and destroyed when it is removed from a table.
The rownum pseudocoloumn returns a number indicating the order in which oracle selects the row from a table or set of joined rows.


1 comment:

Thank you :
- kareem