CHARTOROWID |
CHARTOROWID(char) |
Converts a CHAR or VARCHAR2 value to a ROWID value. The ROWID type in this case is the Oracle7 type.
Example
SQL> SELECT * 2 FROM dual 3 WHERE ROWID = CHARTOROWID('AAAADCAABAAAAVUAAA'); D - X
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.