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'
-
What does it do?– user1822May 16, 2015 at 10:07
-
In SQL Server, it selects 'ABCD'. 0x41424344 is the Hex of 'ABCD'– srpMay 16, 2015 at 10:10
Add a comment
|
1 Answer
SQL> select utl_raw.cast_to_varchar2('41424344') from dual;
UTL_RAW.CAST_TO_VARCHAR2('41424344')
------------------------------------
ABCD
answered May 16, 2015 at 11:42
