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!

Decimal to Hexadecimal convertion

762436Sep 29 2010 — edited Sep 30 2010
Hi, how can I converte decimal(NUMBER) to Hexadecimal in PL/SQL ?

I need to translate the NUMBER: 50545326 to haxadecimal: 030342AE
But my SQL return C43337361B, see below:
SELECT RAWTOHEX( utl_raw.cast_from_number( 50545326 ) )  --> I wish 030342AE value
  FROM DUAL;
This post has been answered by Starlight Rider on Sep 29 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2010
Added on Sep 29 2010
9 comments
22,942 views