Skip to Main Content
Forums

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 number(9) to 64bit Hex

kdwolfJul 5 2008 — edited Jul 21 2008
My client wants me to create an XML file and replace some of the Id's by Hex value, based on 64bit.

to_binary functions didn't help me too much, as well as to_multi_char or to single...
What should be the best way to do it?
I guess that first I need to convert my decimal number to binary, and then - to hex, no?


Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2008
Added on Jul 5 2008
8 comments
2,890 views