ROWIDTONCHAR(x): Converts the ROWID x to an NVARCHAR2 character. : ROWIDTONCHAR « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. ROWIDTONCHAR
SQL>
SQL> SELECT LENGTHB( ROWIDTONCHAR(ROWID) ), ROWIDTONCHAR(ROWID) FROM dual;

LENGTHB(ROWIDTONCHAR(ROWID)) ROWIDTONCHAR(ROWID
---------------------------- ------------------
                          36 AAAAECAABAAAAgiAAA








15.6.ROWIDTONCHAR
15.6.1.ROWIDTONCHAR(x): Converts the ROWID x to an NVARCHAR2 character.
15.6.2.SELECT CAST(NULL AS TIMESTAMP WITH LOCAL TIME ZONE) from dual;