begin
select ....
update test set sal = sal * (1 + 10%) where empnp = yno; --这里应该是加薪10%,话说加薪不是在表中修改数据么?
if month_between(date1,date2) > 60 then --month_between()函数中参数应该是Date类型的吧?
update .... --额外加薪..
else
....
end if;
end;
months_between(sysdate,hiredate)