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