傳入专题

Oracle動態傳入function

一個例子,實現函數/procedure 動態傳入參數變化 CREATE OR REPLACE FUNCTION xx_abc_check_arg(a NUMBER, b NUMBER, d number default 0) RETURN NUMBER ISv_goal NUMBER;BEGINSELECT (a + b+d) INTO v_goal FROM dual;RETURN v_go