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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Encrypting a number into another number?

Re: Encrypting a number into another number?

From: Svend Jensen <svend.s.jensen_at_it.dk>
Date: Wed, 27 Aug 2003 22:31:09 +0200
Message-ID: <3f4d14f8$0$32533$edfadb0f@dread16.news.tele.dk>


Pomme-granite wrote:

> I need a simple PL/SQL algorithm for encrypting one integer (up to 6
> digits) into another 6 digit integer, so DBMS_OBFUSCATION_TOOLKIT
> isn't of use. I have already written something which uses simple
> XORing, Newvalue := InputValue XOR bitmask, but patterns still emerge
> for consequetive InputValues.
>
> What I need doesn't have to be too secure, but I do need to give a
> more diverse range in output than simple XORing. Any ideas?
>
> Thanks
> Pomme-granite

A simple solution could be to use the utl_raw package. Convert the number to raw, invert it, do some other 'secret' stuff like byte shuffling, convert back to number.

/Svend
remove the spamkiller [s.] in reply address. Received on Wed Aug 27 2003 - 15:31:09 CDT

Original text of this message

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