Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL function to output number as hexadecimal string?

Re: PL/SQL function to output number as hexadecimal string?

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Fri, 23 Jul 1999 00:48:03 GMT
Message-ID: <7ZOl3.73503$Fz2.11178@news.rdc1.az.home.com>


No, I'm not averse to that at all... in fact, the source of the data is already a column, I just never thought to look for a function name like that... Thanks!

James Lorenzen <james_lorenzen_at_allianzlife.com> wrote in message news:7n229b$tug$1_at_nnrp1.deja.com...
> In article <SGLk3.69981$Fz2.10560_at_news.rdc1.az.home.com>,
> "Kevin P. Fleming" <kfleming_at_access-laserpress.com> wrote:
> > Anyone have one of these beasts already written they'd care to share?
> >
>
> If you are not adverse to imbeded select statements, the following will
> function:
> SELECT RAWTOHEX(value_to_translated) INTO hex_result_in_char FROM dual ;
>
> HTH
> James
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 19:48:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US