create or replace package toyspack asprocedure UpdateToyPrice;
function AvgToyPrice return number;
--cursor pri_cur return my_toys%rowtype;
end toyspack;create or replace package body toyspack ascursor pri_cur return my_toys%rowtype is
select * from my_toys;procedure UpdateToyPrice is
pri number;
begin
select price into pri from my_toys where id='1';
end;
function AvgToyPrice return number is
ave number;
begin
select avg(price) into ave from my_toys;
return ave;
end;end toyspack;--cursor pri_cur return my_toys%rowtype is
select * from my_toys; 这个一定要在第一个的,是吗?
function AvgToyPrice return number;
--cursor pri_cur return my_toys%rowtype;
end toyspack;create or replace package body toyspack ascursor pri_cur return my_toys%rowtype is
select * from my_toys;procedure UpdateToyPrice is
pri number;
begin
select price into pri from my_toys where id='1';
end;
function AvgToyPrice return number is
ave number;
begin
select avg(price) into ave from my_toys;
return ave;
end;end toyspack;--cursor pri_cur return my_toys%rowtype is
select * from my_toys; 这个一定要在第一个的,是吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货