Oracle Conversion Function - Oracle/PLSQL ROWIDTOCHAR Function

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

Example


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

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

SQL>