Purpose
This function converts a ROWID value to a value of the VARCHAR2 data type.
Syntax
ROWIDTOCHAR(rowid)
Parameters
The rowid parameter is a value of the ROWID data type.
Return type
VARCHAR2
Examples
Query data in the ROWID column of the tbl1 table where the value is AAIKA.
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