Oracle PL/SQL/Conversion Functions/chartorowid
Use chartorowid
SQL>
SQL>
SQL> select chartorowid("AAAH14AABAAAO+HAAI") from dual;
CHARTOROWID("AAAH1
------------------
AAAH14AABAAAO+HAAI
1 row selected.
SQL>
SQL> --
SQL>
SQL>
SQL> select chartorowid("AAAH14AABAAAO+HAAI") from dual;
CHARTOROWID("AAAH1
------------------
AAAH14AABAAAO+HAAI
1 row selected.
SQL>
SQL> --