1. Using Cursors Write a program that gives all employees in department MCA and 15% pay increase. Display a message displaying how many Employees were awarded the increase.
cursor empcursor2 is select name,dname,salary,e.deptno from employee e,department where
e.deptno=department.deptno and dname=’Research’;
fetch empcursor2 into v_name,vdname,vsal,vdno;
exit when empcursor2%notfound;
update employee set salary=salary+salary*0.15 where deptno=vdno;
dbms_output.put_line(count ||’ Number of people have been awarded 15% increase in ‘|| vdname);