December 2002
Intermediate to advanced
928 pages
85h 29m
English
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:
OOOOOOFFFBBBBBBRRRwhere:
| 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. |