23. Explain ROWID in Oracle.

ROWID is a unique hexadecimal value which Oracle inserts to identify each record being inserted. It is
used for all Full Table scans.

Structure:

OOOOOOFFFBBBBBBRRR

OOOOOO -    First six characters is the Object Number which idenities the Data Segment
FFF           - Next 3 characters is the Database File number
BBBBBB     - Next 6 characters shows the DataBlock number
RRR           -Next 3 characters identified the Row within the block