Re: XOR and HEX in PL/SQL

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 06 Oct 1998 19:11:38 GMT
Message-ID: <361a6af0.6713462@news.siol.net>

On Tue, 06 Oct 1998 16:55:18 GMT, hvande_at_sapient.com wrote:

>Does anybody know if Oracle supports some of the following functionality. Or
>do people know if there are PL/SQL functions that people wrote.
>
>- Do an XOR on two strings

Look at the supplied package UTL_RAW. There you'll find a set of binary functions (AND, OR, XOR, COMPLEMENT).

>- Convert a string to it's hexadecimal values

If you mean converting numbers from decimal to hex, you can (quite simply) write your own conversion function. There were some examples of such functions/packages presented in this newsgroup in the past, so you can search archives for it if you don't wan't to reinvent a wheel.

>Thanks,
>
>Henri

HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Oct 06 1998 - 14:11:38 CDT