previously in my database the data have stored as compressed.
now i want to retrieve the data into to number format;
my select query like this:
SELECT RAWTOHEX(SUBSTR(DIRDEPINFO_001,37,6)) FROM DIRDEPDETL WHERE VENDOR = 12345;
result is:
RAWTOHEX(SUBSTR(DIRDEPINFO_001,37,6))
-------------------------------------
00000050000C
now i wan to convert to number format??/