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'
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI'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> select utl_raw.cast_to_varchar2('41424344') from dual;
UTL_RAW.CAST_TO_VARCHAR2('41424344')
------------------------------------
ABCD