Is there any function in oracle to convert decimal values to hexa decimal values? or do we need to create our own userdefined function for this?
asked Dec 15, 2009 at 06:17 PM in Default
Converting to Hexadecimal
Does Oracle have a function or an easy way to convert hexadecimal to decimal or decimal to hexadecimal?
As a matter of fact, since Oracle8i Release 8.1.5, we do. It is a simple to_number/to_char format mask for numbers. You can use the query select to_number( 'AA', 'xx' ) from dual; to convert from hexadecimal to decimal and select to_char( 111, 'xxxx' ) from dual to convert from decimal to hexadecimal.
Check CONVERT function as well