Post date: 04-Feb-2010 15:08:26
Decimal to Hexadecimal Conversion
=============================
SQL> select to_char(1279578,'XXXXXXXXX') from dual;
TO_CHAR(12
----------
13865A
Hexadecimal to Decimal Conversion
=============================
SQL> select to_number('13865A','XXXXXXXX') from dual;
TO_NUMBER('13865A','XXXXXXXX')
------------------------------
1279578