Oracle SQL: the Essential Reference

ROWIDTOCHAR

ROWIDTOCHAR(rowid)

Converts a ROWID value to a character string.

Example

The following example uses the ROWIDTOCHAR function to explicitly convert a ROWID value to a character string:

SQL> SELECT ROWID, ROWIDTOCHAR(ROWID) FROM dual;

ROWID              ROWIDTOCHAR(ROWID)
------------------ ------------------
AAAADCAABAAAAVUAAA AAAADCAABAAAAVUAAA

As this example shows, ROWID values are implicitly converted to character strings whenever you select them from a table using SQL*Plus. For this reason, you often see SELECT statements that retrieve ROWIDs, but that do not explicitly convert them.