Purpose
The CHARTOROWID function converts a string of the CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type to the ROWID data type.
Syntax
CHARTOROWID(char)
Parameters
The char parameter is a string that conforms to the ROWID format, for example, "*AAIKAQAAAAAAAAA=".
Return type
The ROWID data type.
Examples
Convert the string *AAIKAQAAAAAAAA/= to a value of the ROWID data type.
obclient> SELECT CHARTOROWID('*AAIKAQAAAAAAAA/=') FROM DUAL;
+----------------------------------+
| CHARTOROWID('*AAIKAQAAAAAAAA/=') |
+----------------------------------+
| *AAIKAQAAAAAAAA8= |
+----------------------------------+
1 row in set