regarding fetch across commits
is the following valide? is it good?
if it is not, what's other choice?
cursor tab_row is select name,num_years_worked from names;
for my_row in tab_row loop
if my_row.num_years_worked>5 then
update names set eligible_for_award='Y' where current of tab_row;