select utl_raw.cast_to_varchar2(hextoraw('534d495448')) from dual : utl_raw « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. utl_raw
SQL>
SQL>
SQL> select utl_raw.cast_to_varchar2(hextoraw('534d495448')) from dual;
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('534D495448'))
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SMITH

SQL>








31.39.utl_raw
31.39.1.utl_raw.cast_to_raw
31.39.2.Use utl_raw.cast_to_raw to convert string to raw
31.39.3.select utl_raw.cast_to_varchar2(hextoraw('787878')) from dual
31.39.4.select utl_raw.cast_to_varchar2(hextoraw('534d495448')) from dual
31.39.5.Difference between utl_raw.length and length
31.39.6.Use utl_raw.substr