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