All,
I want to break down this hex string into two hex digits at a time and convert them into DECIMAL and ASCII.
So for example 03b5016f8b5dc59a would break down to 03 b5 01 etc
Then each on of those would be turned into its DECIMAL and ASCII equivelant and joined back together.
HEX DECIMAL ASCII
03b5016f8b5dc59a = 11121123123132 = ABCASDKDKAKSKD <-- For example not the real numbers used :)
WITH random_hex AS
(
SELECT '03b5016f8b5dc59a' AS HEX FROM DUAL UNION ALL
SELECT '02c40177c7467f8e' FROM DUAL UNION ALL
SELECT '03b9016f8bc645e9' FROM DUAL
)
SELECT hex
FROM random_hex
;