ROWIDTONCHAR

ROWIDTONCHAR(x) Converts the ROWID x to an NVARCHAR2 string.


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

ROWIDTONCHAR(CHART
------------------
AAABABAADAAAAAPAAA

SQL>