Kytcs
Find Total score
declare
s
Score.Score%type;
cursor c is select sum(Score) from Scores where Score <100;
begin
open c;
fetch c into s;
dbms_output.put_line('Total='||s);
close c;
end;
/
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment