Read Best Answer

Editorial / Best Answer

rishipahuja  

 Profile Answers by rishipahuja Questions by rishipahuja

• Member Since Aug-2006 | Aug 6th, 2006

---

rowid has a physical significance i.e you can read a row if you know rowid. It is complete physical address of a row.

While rownum is temporary serial number allocated to each returned row during query execution.

vinay

• Sep 20th, 2015

It it will be re-assigned to a different row when inserted by Oracle.

Arif

• Jul 3rd, 2015

I have one doubt like you said that rowid is automatically created when we add a row(record) then what happens to rowid
when we delete that record?

Improve Answer