ROWIDTOCHAR

ROWIDTOCHAR(x) converts the ROWID x to a VARCHAR2 string.


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

ROWIDTOCHAR(CHARTO
------------------
AAABABAADAAAAAPAAA

SQL>