0

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'

2
  • What does it do?
    – user1822
    May 16, 2015 at 10:07
  • In SQL Server, it selects 'ABCD'. 0x41424344 is the Hex of 'ABCD'
    – srp
    May 16, 2015 at 10:10

1 Answer 1

0
SQL> select utl_raw.cast_to_varchar2('41424344') from dual;

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.