ROWIDTOCHAR

Syntax

Description of rowidtochar.gif follows
Description of the illustration rowidtochar.gif

Purpose

ROWIDTOCHAR converts a rowid value to VARCHAR2 datatype. The result of this conversion is always 18 characters long.

Examples

The following example converts a rowid value in the employees table to a character value. (Results vary for each build of the sample database.)

SELECT ROWID FROM employees 
 WHERE ROWIDTOCHAR(ROWID) LIKE '%JAAB%';
ROWID
------------------
AAAFfIAAFAAAABSAAb