Purpose
You can call this function to convert 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 column ROWID in table tbl1.
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