=============암호화====================== 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..