Thursday, March 14, 2013

What is the difference between ROWNUM and ROWID in Oracle?

ROWID is the unique physical address of every row of a table maintained by database automatically. ROWNUM is the sequential number allocated to each row in the result set object during query execution.

ROWID is permanent whereas ROWNUM is temporary. ROWID is 16-bit hexadecimal whereas ROWNUM is numeric.

2 comments :

Anonymous said...

Best One

Anonymous said...

Short and Simple.... That's Cool....
Very useful for me..