Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert to number format from hexa

V prasadMay 7 2011 — edited May 7 2011
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??/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2011
Added on May 7 2011
3 comments
169 views