What is ROWID

Editorial / Best Answer

Answered by: Zimmy

  • Jul 9th, 2005


ROWID is the psedo columns indicate the stored location of the data physically in the database.

Showing Answers 1 - 4 of 4 Answers

Zimmy

  • Jul 9th, 2005
 

ROWID is the psedo columns indicate the stored location of the data physically in the database.

  Was this answer useful?  Yes

Mangai Varma

  • Aug 31st, 2006
 

Rowid is the physical address for each record in the database and it is a fixed-length binary data.

The format of the rowid is:

BBBBBBB.RRRR.FFFFF

where:

BBBBBBB is the block in the database file;

RRRR is the row in the block;

FFFFF is the database file.

Ravi Gajula

  • Jun 17th, 2009
 

The Address Field of the index is called ROW ID

Format: BBBBBBB.RRRR.FFFF
FFFF: Unique Number given by oracle engine to each Data file
BBBBBBB: each Data File is further divided in Data Blocks
RRRR: Data Blocks can store one or more Records

  Was this answer useful?  Yes

vikas

  • Dec 21st, 2012
 

but according to you it has 16 digits ... and according to my oracle 10g it is showing 18 digits. like AAAC9EAAEAAAABXAAA .. why??

  Was this answer useful?  Yes

Ravi

  • Jul 3rd, 2013
 

ROWID: It is pseudo column,it has physical address location of row in ORACLE database
The format is: OOOOOO.FFF.BBBBBB.RRR
OOOOOO is the object ID
FFF is the file number
BBBBBB is the block number
RRR is the row number

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions