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 community