Rowidtonchar

Description: ROWIDTONCHAR converts a rowid value to NVARCHAR2 datatype. The result of this conversion is always in the national character set and is 18 characters long.

ROWIDTOCHAR(ROWID)
 
 
-- The following w3mentor converts a rowid value to an NVARCHAR2
-- string:
 
SELECT LENGTHB( ROWIDTONCHAR(ROWID) ), ROWIDTONCHAR(ROWID)
   FROM employees;
 
LENGTHB(ROWIDTONCHAR(ROWID)) ROWIDTONCHAR(ROWID
---------------------------- ------------------
                          36 AAAFfIAAFAAAABSAAA

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.