Purpose
ROWIDTOCHAR() converts a rowid value to a value of the VARCHAR2 data type.
Syntax
ROWIDTOCHAR(rowid)
Parameters
rowid is a value in the ROWID format.
Return type
The return type is VARCHAR2.
Examples
The following example retrieves data that contains AAIKA from the ROWID column in the tbl1 table.
obclient> SELECT LENGTHB(ROWIDTOCHAR(ROWID)),ROWIDTOCHAR(ROWID)
FROM tbl1
WHERE ROWIDTOCHAR(ROWID) LIKE '%AAIKA%';
+-----------------------------+--------------------+
| LENGTHB(ROWIDTOCHAR(ROWID)) | ROWIDTOCHAR(ROWID) |
+-----------------------------+--------------------+
| 17 | *AAIKAQAAAAAAAAA= |
| 17 | *AAIKAgAAAAAAAAA= |
| 17 | *AAIKAwAAAAAAAAA= |
+-----------------------------+--------------------+
3 rows in set