Mega Code Archive

 

Categories / Oracle PLSQL / Conversion Functions

 

Use chartorowid

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