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