-------------------------------------------------------
-- 奖学金标准设立修改,特等奖--
-------------------------------------------------------
declare
v_class_counter varchar2(30);
v_averscore_max number;
v_averscore_min number;
begin
for j in 1..3 loop
for i in 1..6 loop
if i<=1 then
v_class_counter :='特定等奖';
v_averscore_min :=86;
v_averscore_max :=100;
if i<=2 then
v_class_counter :='一等奖';
v_averscore_min :=85;
v_averscore_max :=999;
elsif i<=3 then
v_class_counter :='二等奖';
v_averscore_min :=80;
v_averscore_max :=84;
elsif i<=4 then
v_class_counter :='三等奖';
v_averscore_min :=75;
v_averscore_max :=79;
elsif i<=5 then
v_class_counter :='鼓励奖';
v_averscore_min :=70;
v_averscore_max :=74;
else
v_class_counter :='任何奖';
v_averscore_min:=60;
v_averscore_max:=69;
end if;
insert into sqs_scholarship_7720
( scholar_id,
subject_id,
scholar_class,
sigle_averscore_min,
sigle_averscore_max,
created_by,
creation_date,
last_updated_by,
last_update_date
)
values(sqs_scholarship_7720_s.nextval,
j,
v_class_counter,
v_averscore_min,
v_averscore_max,
'yu',sysdate,'lee',sysdate);
end loop;
end loop;
end;
|