Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Select utl_raw cast_to_varchar2(hextoraw(534d495448)) from dual

SQL> SQL> select utl_raw.cast_to_varchar2(hextoraw('534d495448')) from dual; UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('534D495448')) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SMITH SQL>