Oracle PL/SQL Tutorial/Conversion Functions/ROWIDTONCHAR

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

   <source lang="sql">

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

---

------------------

                         36 AAAAECAABAAAAgiAAA</source>
   
  

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

   <source lang="sql">

CAST(NULLASTIMESTAMPWITHLOCALTIMEZONE)

---

</source>