Re: long numeric to headecimal

A copy of this was sent to "pippo" <pippo_at_pippo.it> (if that email address didn't require changing) On Mon, 20 Sep 1999 11:55:12 +0200, you wrote:

>I need to trasform a long number into hexadecimal form in PL/SQL.
>Is there anyone that tell me how ?
>
>with regard

In addition to the "Base Conversion Functions" available from the site in the signature, in Oracle8i, release 8.1 you can:

tkyte_at_8i> select to_char( 123, 'xxxx' ) from dual;

TO_CH

   7b

  1* select to_number( '7b', 'xx' ) from dual tkyte_at_8i> /

TO_NUMBER('7B','XX')

                 123

'xxxxx' is a new format you can use for Hex input/output of numbers in 8.1

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 20 1999 - 07:21:18 CDT