CHARTOROWID

chartorowid function converts a char, varchar2, nchar, or nvarchar2 to a rowid. The format of CHARTOROWID is:

The format of the rowid is:

where:

• BBBBBBB is the block in the database file;
• RRRR is the row in the block;
• FFFFF is the database file.

SQL> select chartorowid('AAABABAADAAAAAPAAA') from dual;

CHARTOROWID('AAABA
------------------
AAABABAADAAAAAPAAA

SQL>


select * from emp where rowid = chartorowid('AAABABAADAAAAAPAAA');