Purpose
ROWIDTONCHAR() converts a rowid value to a value of the NVARCHAR2 data type.
Syntax
ROWIDTONCHAR(rowid)
Parameters
rowid is a value in the ROWID format.
Return type
The return type is NVARCHAR2.
Examples
The following example converts the ROWID values in table tbl1 to values of the NVARCHAR2 data type and returns the corresponding lengths in bytes.
obclient> SELECT LENGTHB(ROWIDTONCHAR(ROWID)),LENGTHB(ROWID),ROWIDTONCHAR(ROWID) FROM tbl1;
+------------------------------+----------------+---------------------+
| LENGTHB(ROWIDTONCHAR(ROWID)) | LENGTHB(ROWID) | ROWIDTONCHAR(ROWID) |
+------------------------------+----------------+---------------------+
| 34 | 17 | *AAIKAQAAAAAAAAA= |
| 34 | 17 | *AAIKAgAAAAAAAAA= |
| 34 | 17 | *AAIKAwAAAAAAAAA= |
+------------------------------+----------------+---------------------+
3 rows in set