Kytcs: 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