Oracle Equivalent of the following SQL Server syntax I'm looking for the Oracle equivalent of the following SQL Server syntax:

select Cast(0x41424344 as varchar(max))


In SQL Server, it selects  'ABCD'. 

0x41424344 is the hex of 'ABCD'
SQL&gt; select utl_raw.cast_to_varchar2('41424344') from dual;

UTL_RAW.CAST_TO_VARCHAR2('41424344')
------------------------------------
ABCD