select * frm user_login_table where password = SHA1('MYPassword');

CREATE OR REPLACE procedure MUNGAI.p_auth_insert_user (par_username in varchar2,
                              par_password in varchar2,
                              par_work in varchar2
                             )
  is
    l_hash raw(2000);
  begin
    l_hash :=
     dbms_crypto.hash
       (utl_i18n.string_to_raw (par_password || par_work || upper(par_username),
                                'AL32UTF8'
                               ),
        dbms_crypto.hash_sh1
       );

  insert into user_login_table
    (user_name, p_word, work_class)
     values
    (par_username, l_hash, par_work);
 end p_auth_insert_user;
/

exec MUNGAI.p_auth_insert_user('MUNGAI', 'gatungo', '999')

select *
  from user_login_table
 where password = dbms_crypto.hash( utl_i18n.string_to_raw( 'MYPassword', 'AL32UTF8' ),
                                    <<whatever hash algorithm you want to use>> );

select *
  from user_login_table
 where password = new_function_name( 'MYPassword' )
   and username = 'YourUserName'

CREATE OR REPLACE function MUNGAI.hash_password(par_username in varchar2,
                              par_password in varchar2,
                              par_work in varchar2
                             )
  return raw
is
  l_hash raw(2000);
begin
  l_hash :=
   dbms_crypto.hash
     (utl_i18n.string_to_raw (par_password || par_work || upper(par_username),
                              'AL32UTF8'
                             ),
      dbms_crypto.hash_sh1
     );
  return l_hash;
end;

CREATE OR REPLACE procedure MUNGAI.p_auth_insert_user (par_username in varchar2,
                              par_password in varchar2,
                              par_work in varchar2
                             )
is
  l_hash raw(2000);
begin
  l_hash := hash_password( par_username, par_password, par_work );

  insert into user_login_table
    (user_name, p_word, work_class)
   values
    (par_username, l_hash, par_work);
end p_auth_insert_user;
/

select *
  from user_login_table
 where password = new_function_name( username,
                                     'MYPassword',
                                     <<whatever `par_work` is supposed to be>> )
   and username = 'YourUserName'