Re: Hexdecimal output

From: Kirk Bradley <kbradley_at_us.oracle.com>
Date: 1997/04/11
Message-ID: <kbradley-ya023180001104971726520001@192.86.155.83>#1/1

write yourself a function in pl/sql to do it.. since oracle numbers are not like machine integers you could end up with many hex digits to represent something..

In article <334D1570.13A3_at_detroitedison.com>, lechkung_at_detroitedison.com wrote:

> Hi,
> This may seem very easy to most of you out there, but how do you output
> a NUMBER in a hexdecimal form??
>
> ex: $ SELECT status_flag FROM remote_control_units;
> ^
> |
> +---- This is what I want in hex form (0xfffffff)
>
> Thanks
> Greg Lechkun
> lechkung_at_detroitedison.com
> lechkung_at_tir.com
Received on Fri Apr 11 1997 - 00:00:00 CDT