CHARTOROWID

Syntax

Purpose

CHARTOROWID converts a value from CHAR or VARCHAR2 datatype to ROWID datatype.

Example

SELECT ename FROM emp
   WHERE ROWID = CHARTOROWID('AAAAfZAABAAACp8AAO');
 
ENAME
----------
LEWIS