How to get the summ of all values

Question

I have this piece of code PL/SQL code in a procedure

for rec in(select t.val, t.cat from table t where a=1)
Loop
v:=(rec.val*rec.cat)/2;
end Loop;

How I can get the sum of all 'v' values?

Answer 1

This will create the sum in another variable, named tempSum

DECLARE
tempSum number (6);

tempSum := 0;

for rec in(select t.val, t.cat from table t where a=1)
Loop
v:=(rec.val*rec.cat)/2;
tempSum := tempSum + V;
end Loop;

Answer 2

Best way:

select sum(t.val * t.cat / 2) into l_val_cat_sum from table t where a = 1;