Oracle的function

写在这里，以便于以后忘记格式后可以查询。

CREATE OR REPLACE FUNCTION TEMP_FUNC_WYL(PI_AAA100 VARCHAR2,
                                         PI_AAA102 VARCHAR2)
--字典转换，把代码值转换成对应的可理解的中文,wyl,20141105
 RETURN VARCHAR2 IS
  V_AAA103 VARCHAR2(1000);
BEGIN
  SELECT AAA103
    INTO V_AAA103
    FROM AA10 A
   WHERE A.AAA100 = PI_AAA100
     AND A.AAA102 = PI_AAA102;
  RETURN V_AAA103;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE(‘没有找到数据‘);
END;

Oracle的function

标签：