Difference between rowid and rownum?

Posted by silpa on Sep 11 2007

rownum is temporary serial number allocated to each returned row in query execution

rowid is physical address of a row
one can read a row if one know row id

Leave a Comment