Ora2pg1 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 var.. DataBase/PostgreSQL 2021. 4. 28. 이전 1 다음