create package testpack --创建一个包头,里面定义变量和方法名称,方法参数,返回值类型
is
v_tax number;
v_s number;
Function tax(v_money number) return number;
function addd(v_a number,v_b number) return number;
end testpack;
create package body testpack --创建包体,里面具体实现包头定义的方法.注意格式
is
function tax(v_money number) return number is
begin
if(v_money<3500) then null;
elsif(v_money>=3500 and v_money<5000) then v_tax := (v_money-3500)*0.03-0;
elsif(v_money>=5000 and v_money<8000) then v_tax := (v_money-3500)*0.1-105;
elsif(v_money>=8000 and v_money<12500) then v_tax := (v_money-3500)*0.2-555;
is
v_tax number;
v_s number;
Function tax(v_money number) return number;
function addd(v_a number,v_b number) return number;
end testpack;
create package body testpack --创建包体,里面具体实现包头定义的方法.注意格式
is
function tax(v_money number) return number is
begin
if(v_money<3500) then null;
elsif(v_money>=3500 and v_money<5000) then v_tax := (v_money-3500)*0.03-0;
elsif(v_money>=5000 and v_money<8000) then v_tax := (v_money-3500)*0.1-105;
elsif(v_money>=8000 and v_money<12500) then v_tax := (v_money-3500)*0.2-555;