Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL function to output number as hexadecimal string?
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
![]() |
![]() |