| 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. |
Wednesday, November 30, 2011
Differences between rowid and rownum
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment