Definition:
In Oracle PL/SQL, the ROWIDTONCHAR function is used to convert a ROWID to its equivalent NVARCHAR2 value.
Example Syntax:
ROWIDTONCHAR(n)
In the syntax example above, "n" is of the ROWID type.
Example Usage:
The SQL query below converts a ROWID column to its NVARCHAR equivalent.
SQL> SELECT ROWIDTONCHAR(ROWID) FROM T_ROW;
ROWIDTONCHAR(ROWID)
------------------
AAAIYxAABAAAMiSAAA
AAAIYxAABAAAMiSAAB
Related Links:
Related Code Snippets:
- ROWIDTONCHAR - ROWIDTONCHAR converts a rowid value to NVARCHAR2 datatype. The result of this conv...
