sharmasl

 Profile Answers by sharmasl 

• Mar 24th, 2009

 

IN 18 Character Long ROWID constructed as-

1 to 6 character are database object no.
7 to 9 character are file no.
10 to 15 character are block no.
16 to 18 character are rowno.

like this 18 character of rowid are constructed.....

imtiazali

 Profile Answers by imtiazali 

• Jun 5th, 2009

 

Rowid and Rownum are psuedocolumns for every table Oracle provides unique rowid, rownum.
Rowid are in alphanumeric, rowid are 18 character, for every rowid last 3 character will be changed.

sandip01

 Profile Answers by sandip01 Questions by sandip01

• May 25th, 2010

 

ROWID is internally constructed when a new row is added.
BBBBBB.RRRRRR.FFFFFF

BBBBBB - Represents the blocks in the datafile.
RRRRRR - Represents the rows in the block.
FFFFFF - Represents the file no.