Zimmy

• Jul 9th, 2005

 

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

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

 Profile Answers by 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

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??

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