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

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Tue, 20 Jul 1999 14:49:21 GMT
Message-ID: <7n229b$tug$1@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 Tue Jul 20 1999 - 09:49:21 CDT

This message: [ Message body ]
Next message: Kevin A Lewis: "V$LOGHIST content cutoff criteria"
Previous message: Douglas Whitacre: "Timing out connections?"
In reply to: Kevin P. Fleming: "PL/SQL function to output number as hexadecimal string?"
Next in thread: Kevin P. Fleming: "Re: PL/SQL function to output number as hexadecimal string?"
Reply: Kevin P. Fleming: "Re: PL/SQL function to output number as hexadecimal string?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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