DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: encryption

Hybrid View

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    encryption

    Hi,
    I have an encryption logic which is as below, which encrypts and alphabet to alphabet

    The input is passed in this (----) place

    select chr(mod(ascii(----) - ascii('a') + 541 , ascii('z') - ascii('a')) + ascii('a')) from dual

    541 is a seed value based on userid which changes for different logins.

    With this (a) and (z) are encrypted to the same value, and hence i am facing problems in decrypting.

    can somebody help in changing the above encrption logic.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Shouldn't you be using the obfuscation tool kit?

    http://download-west.oracle.com/docs...04.htm#1004955

  3. #3
    Join Date
    Feb 2005
    Posts
    158
    You really want to use MOD 26 (whereas ASCII z - ASCII a is 25)

    SELECT CHR(MOD(ASCII('.') - 97 + 541 , 26) + 97) FROM dual

    I guess you realise this only 'encrypts' a single character.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width