The PL/SQL package
dbms_rowid
provides the some functions such as
rowid_block_number
,
rowid_relative_fno
and
rowid_row_number
which allow to determine the block number and the record number within this block of a given record, which is identified by its
rowid.
Depending on the size of a
LOB and its column's configuration (especially the
enable/disable storage in row
clause), LOB data is stored in the same data block as the record/row to which it belongs (in row storage) or in a special LOB segment.