Question: Write a PL / SQL block to increment IT department salaries by 1 0 % . Display IT department total salaries before and after the

Write a PL/SQL block to increment IT department salaries by 10%.
Display IT department total salaries before and after the increment on two lines:
Total Salaries Before Increment [amount]
Total Salaries After Increment [amount]
Schema
There is 1 table: EMPLOYEE
\table[[EMPLOYEE,],[Name,Type,Description],[EMPLOYEE_ID,NUMBER (6),unique id, the primary key.],[EMPLOYEE_NAME,VARCHAR2(25),employee name],[SALARY,NUMBER (8,2),monthly salary],[DEPARTMENT_NAME,VARCHAR2(25),department name]]
Sample Data Tables
\table[[EMPLOYEES],[EMPLOYEE_ID,EMPLOYEE_NAME,SALARY,DEPARTMENT_NAME],[1,Dylan Becker,1000,IT],[2,Giovanny Keith,2000,IT],[3,Skyler Luna,3500,IT],[4,Kaiya Everett,7000,SALES]]
Sample Output
Total Salaries Before Increment 6500
Total Salaries After Increment 7150
 Write a PL/SQL block to increment IT department salaries by 10%.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!