Oracle to PostgreSQL Migration Function 함수 변환 (적용예시)

Oracle

create FUNCTION FN_GET_CODE_NM(v_upper_code_id in varchar2, v_code_id in varchar2)
    return varchar2 is
    code_nm VARCHAR2(100) := '';
begin
    SELECT CODE_NM INTO code_nm
    FROM CMT_CODE_CT_NEW
    WHERE UPPER_CODE_ID = v_upper_code_id
      AND CODE_ID = v_code_id
      AND USE_AT = 'Y';
    return code_nm;
exception when others then
    return null;
end;

 

PostgreSQL

create FUNCTION FN_GET_CODE_NM(v_upper_code_id in varchar, v_code_id in varchar)
    returns varchar as
$$
begin
-- SQLINES LICENSE FOR EVALUATION USE ONLY
return (SELECT CODE_NM INTO code_nm
FROM CMT_CODE_CT_NEW
WHERE UPPER_CODE_ID = v_upper_code_id
  AND CODE_ID = v_code_id
  AND USE_AT = 'Y');

exception when others then
    return null;
end;
$$ language plpgsql;