Conversion of a number from decimal to hexa decimal?

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 '09 at 06:17 PM in Default

dbkid
131 ● 3 ● 8 ● 10

(comments are locked)

1 answer:

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.

Oracle Resource

Check CONVERT function as well

Oracle Resource

answered Dec 15 '09 at 06:34 PM

Tariq Rahiman
665 ● 1 ● 2 ● 4

The first link helped me to do this. But the second one it seems, there is no option using CONVERT function to do that. Thank you so much Tariq Rahiman!!

Dec 15 '09 at 07:05 PM dbkid

(comments are locked)