| 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
![]()  | 
![]()  |