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!

How to convert binary to hexadecimal

user5914526Aug 30 2011 — edited Aug 30 2011
Hi guys,

I have a string variable with whose value is binary and I need to convert this binary value to hexadecimal value.

For instance:

declare
v_StrBinary varchar2(100) := '1001';
v_Hexa_Result varchar2(100);
begin

v_hexa_result := FUNC_???( v_StrBinary ); --> here I need to convert this binary value to hexadecimal value

dbma_output.put_line( v_hexa_result ); --> need to result in '9' value

end;
/

Thank you,
Luciana
This post has been answered by BluShadow on Aug 30 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2011
Added on Aug 30 2011
4 comments
1,028 views