728x90 반응형 dual1 oracle sql function, dual,upper ed fn_sum2 create or replace function fn_sum2(v_sum1 in number,v_sum2 in number)return numberis v_sum number;beginv_sum :=v_sum1 + v_sum2;return v_sum;end;/@fn_sum2variable sum number;execute :sum :=fn_sum2(10,20)print sum; select fn_sum2(10,20) from dual; --------------------------------------ed sum_dept; create or replace function sum_dept(v_deptno in dept.deptno%type)return number isv_sum num.. 2015. 10. 6. 이전 1 다음 728x90 반응형