How to decrypt the hex to numbers...

[syncdba]

Hi ,
I have a table with column C1 as Hexnumbers
-----
H7JIKO9JKUI9KOLJK...etc
I'm trying to convert these hex numbers to phone number because the ohone numbers are encrypted..

Is there a way to do this?
Thanks in advance..

 

[Dagon]

'H7JIKO9JKUI9KOLJK' is not a valid hex number in my book. If you use a valid number, the following works:

select to_Number('ABCDEF', 'XXXXXX') FROM DUAL

 

[taupirho]

Er, hex numbers range from 0 through to F so I dont know how you get K,L and I's in there . Whatever this is, it isn't a hex number.

 

[LKBrwnDBA]

Maybe its a "HEXED" number?

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[cmmrfrds]

It could be binary data in a RAW datatype.

Here is a link to functions to convert RAW data.

http://www.psoug.org/reference/utl_raw.html