DBMS-Lab_Solution - Solution for DBMS Lab Assignments of PL\/Sql(Trigger Cursor Procedure ASSIGNMENT-9 Create a explicit cursor which updates the salary
DBMS-Lab_Solution - Solution for DBMS Lab Assignments of...
100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 3 out of 4 pages.
Solution for DBMS Lab Assignments of PL/Sql (Trigger, Cursor, Procedure)ASSIGNMENT-9Create a explicit cursor which updates the salary of an employee such that,1.If salary > 10000, then increase the salary by 15%2.If 5000<salary <10000, then increase the salary by 12%3.Otherwise, increase the salary by 25%