--package create or replace package p_name asfunction f_name(v1 in out number) return number; procedure p_name(v1 in out number);end p_name;--package bodycreate or replace package body p_name isfunction f_name(v1 in out number) return number isv2 number;beginreturn v2;end;--function create or replace function f_name(v1 in out number) return number isv2 number;beginv2 := v1; return v2;end;几种写法都给你 你自己参考了写吧。。。
function fun_test(para number,type number)return varchar2isquantity number(15,2):=0;temp number(15,2):=0;begin if type = 1then selete sum(1) into temp from table where 条件; quantity:=quantity+temp; dbms_output.put_line(temp); return quantity end if;end;