ROWID_BLOCK_NUMBER

This function shows the block number for the given rowed.

Example:

select id,name,DBMS_ROWID.ROWID_BLOCK_NUMBER(rowid) from emp;

ID

NAME

DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)

1

Robin

981420

2

Thomas

981420

3

Siyam

981421

Comments