Oracle Function for Password encryption

This code shows the password enryption logic in oracle database


CREATE OR REPLACE FUNCTION pass_encrypt( p_usernam IN VARCHAR2, p_password IN VARCHAR2 ) RETURN VARCHAR2
IS
BEGIN
RETURN LTRIM( TO_CHAR( dbms_utility.get_hash_value( UPPER(p_usernam)||'/'||UPPER(p_password),
10000, POWER(2,30) ),
RPAD( 'X',29,'X')||'X' ) );
END pass_encrypt;
/


Comments

Guest Author: gaz11 Jun 2013

how to decrypt it's orginal value in C#



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: