Rowidtochar

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

ROWIDTOCHAR(ROWID);
 
-- The following w3mentor converts a rowid value in the
-- employees table to a character value.
 
SELECT ROWID FROM employees
   WHERE ROWIDTOCHAR(ROWID) LIKE '%JAAB%';
 
ROWID
------------------
AAAFfIAAFAAAABSAAb

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.