Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Encrypting a number into another number?
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