SQL> create table hashp (username varchar2(5), passwd number)
  2  /

Table created

SQL> declare
  2    uname varchar2(5) := 'rhani';
  3    pwd   varchar2(5) := 'passw';
  4  begin
  5    dbms_output.put_line('inserting password..');
  6    insert into hashp values(uname, dbms_utility.get_hash_value(uname || pwd, 10000,10240));
  7    commit;
  8  end;
  9  /

inserting password..

PL/SQL procedure successfully completed

SQL> declare
  2    uname varchar2(5) := 'rhani';
  3    pwd varchar2(5) := 'passx';
  4    vhash number;
  5  begin
  6    select passwd
  7    into vhash
  8    from hashp
  9    where username = 'rhani';
 10    if vhash = dbms_utility.get_hash_value(uname || pwd, 10000,10240) then
 11       dbms_output.put_line('valid password');
 12    else
 13       dbms_output.put_line('invalid password');
 14    end if;
 15  end;
 16  /

invalid password

PL/SQL procedure successfully completed