What is ROWID ?

ROWID is a pseudo column attached to each row of a table. It is 18 character long, blockno, rownumber are the components of ROWID.

Interview Candidate
Sep 7th, 2004
4
1854

SQL Plus

Answer

First
Prev
Next
Last

Showing Answers 1 - 4 of 4 Answers

tarun1282
Profile Answers by tarun1282

Apr 27th, 2006

rowid is a uniquely identified number to each row which is given by the oracle server automatically

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 8th, 2006

rowid is a unique value assigned by system automatically when ever a insert statement gets successful.
rowid contains the address of data file,data block, object id, rownumber