aes 암호화 및 복호화 함수

 

=============암호화======================

DROP FUNCTION IF EXISTS db명.f_encrypt;
CREATE FUNCTION db명.f_encrypt(v_var varchar(20)) RETURNS varchar(100)

BEGIN
  declare return_code varchar(100) default '';
 
  select hex(AES_ENCRYPT(v_var, '암호화키')) into  return_code from dual;
 RETURN return_code;
END;

 

 

 

 

 

==============복호화==================

DROP FUNCTION IF EXISTS db명.f_decrypt;
CREATE FUNCTION db명.f_decrypt(v_var varchar(100)) RETURNS varchar(100)

BEGIN
  declare return_code varchar(100) default '';
 
  select aes_decrypt(unhex(v_var),'복호화키') into  return_code from dual;
 RETURN return_code;
END;