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?
A copy of this was sent to "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
(if that email address didn't require changing)
On Fri, 23 Jul 1999 09:47:49 +0100, you wrote:
>
>rawtohex will not convert numbers in hexadecimal,
>it simply displays in hex the internal storage of the
>number.
>
>I assume you want 11 (dec) -> B (hex)
>
>select rawtohex(11) from dual gives C10C
>q.v.
>select dump(11,16) from dual;
>
>There is a decimal to hex converter on my web-site,
>but this was not written to be particularly efficient.
>
>Thomas Kyte has also published on this newsgroup
>a 'base N to base M' generic conversion package
>which you might find through www.dejanews.com
They are on my web site as well, see the .sig
--
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 Fri Jul 23 1999 - 09:23:55 CDT