Originally Posted by
ecka00
What I really need is to tell Oracle that this string is really a hex string and allow Oracle to convert it as needed. Example:
SELECT to_number('MY_HEX_STRING')
FROM DUAL:
The question is how do I tell Oracle that this is a HEX string?
Here is something what can help you:
http://niigata.cool.ne.jp/j8takagi/hex_to_num.txt
---
Oracle Certified Associate Developer
Data Integrator
Database Software Tester