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.
|
It was clear to understand the differences between rowid & rownum...
ReplyDeleteRegards,
sas training in Chennai|sas course in Chennai