Oracle Conversion Function - Oracle/PLSQL ROWIDTONCHAR Function

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

Example


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

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

SQL>