Oracle in a Nutshell

DBMS_ROWID

Provides routines for working with ROWIDs. ROWIDs changed structure in Oracle8; for Oracle8 and later versions, this package works with both the old and the new ROWID types.

An Oracle7 (restricted) ROWID has three parts in base 16 (hex):

               BBBBBBBB.RRRR.FFFF

An Oracle8 (extended) ROWID has four parts in base 64:

               OOOOOOFFFBBBBBBRRR

where:

OOOOOO is the object number.

FFFF (FFF) is the absolute (Oracle7) or relative (Oracle8) file number.

BBBBBBBB (BBBBBB) is the block number within the file.

RRRR (RRR) is the row number within the block.