Re: hex 2 dec !

Another idea for positive numbers:

SQL> select to_char (123456789, 'XXXXXXXXXXXXXXXXXXXX') from dual;

TO_CHAR(123456789,'XX

              75BCD15 and the reverse

SQL> select to_number ('75BCD15', 'XXXXXXXXXXX') from dual;

TO_NUMBER('75BCD15','XXXXXXXXXXX')

                         123456789

Maybe this is sufficient for you. It has further the advantage that these functions are Oracle internals and therefore very efficiently implemented.

Martin

cc wrote:
>
> hi all,
>
> Could anyone tell me where can I find a fuction in PL/SQL that coverts a
> hexdecimal number to decimal and vice versa. Has anyboby already
> implemented that function?
>
> 10q
Received on Sat Dec 11 1999 - 14:14:33 CST