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
    Commented May 16, 2015 at 10:07
  • In SQL Server, it selects 'ABCD'. 0x41424344 is the Hex of 'ABCD'
    – srp
    Commented 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 you have read our privacy policy.

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