Kytcs.Blogspot.com: Find Total score

Find Total score



declare

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

Followers

Ad Space