Chartorowid – Oracle SQL Function

CHARTOROWID converts a string representation of a ROWID to a ROWID value. The string argument can be a CHAR,VARCHAR2,NCHAR, or NVARCHAR2 data type to ROWID data type.

Example:

SELECT ID from some_table WHERE ROWID = CHARTOROWID(‘AAAAtmAAEAAAAFmAAA’);

ID
——
22