Use chartorowid : chartorowid « Conversion Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Conversion Functions
3. chartorowid

Use chartorowid

 
SQL>
SQL>
SQL>  select chartorowid('AAAH14AABAAAO+HAAI') from dual;
CHARTOROWID('AAAH1
------------------
AAAH14AABAAAO+HAAI

1 row selected.

SQL>
SQL> --

 

Related examples in the same category