Term: ROWIDTOCHAR

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...