Oracle PL/SQL Tutorial/Conversion Functions/ROWIDTONCHAR

ROWIDTONCHAR(x): Converts the ROWID x to an NVARCHAR2 character.

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

SELECT CAST(NULL AS TIMESTAMP WITH LOCAL TIME ZONE) from dual;

CAST(NULLASTIMESTAMPWITHLOCALTIMEZONE)
---------------------------------------------------------------------------