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.
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.