CHARTOROWID

Oracle

Example

SELECT CHARTOROWID ('00007FFF.0000.0001') AS Example
FROM dual;

Output

EXAMPLE
-------------------
00007FFF.0000.0001

Explanation

This example shows the use of the CHARTOROWID function. It converts a character string that represents a ROWID to a ROWID value. The input ‘00007FFF.0000.0001’ is a valid ROWID in hexadecimal format. The function is selecting this ROWID from the dual table which is a single-row, single-column table present by default in Oracle and other database installations. The result is the ROWID ‘00007FFF.0000.0001’, confirming that the CHARTOROWID function has correctly converted the string to a ROWID.