Oracle - Function 예제2

[ Oracle - Function 예제2 ]

 

 

/* 공통코드에서 KNAME 찾기 */ CREATE OR REPLACE FUNCTION DF_COMDT_KNAME (df_cd_head in ytb_comdt.cd_head%type, df_cd_detail in ytb_comdt.cd_detail%type ) RETURN varchar2 is out_str varchar2(30); BEGIN SELECT kn_detail INTO out_str FROM ytb_comdt WHERE cd_head = df_cd_head AND cd_detail = df_cd_detail; RETURN(out_str); EXCEPTION WHEN NO_DATA_FOUND THEN RETURN (' '); END; /