Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

ROWIDTONCHAR(x)

SQL> SQL> SELECT LENGTHB( ROWIDTONCHAR(ROWID) ), ROWIDTONCHAR(ROWID) FROM dual; LENGTHB(ROWIDTONCHAR(ROWID)) ROWIDTONCHAR(ROWID ---------------------------- ------------------                           36 AAAAECAABAAAAgiAAA