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 PLSQL block to increment IT department salaries by
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 table: EMPLOYEE
tableEMPLOYEENameType,DescriptionEMPLOYEEIDNUMBER unique id the primary key.EMPLOYEENAME,VARCHARemployee nameSALARYNUMBER monthly salaryDEPARTMENTNAME,VARCHARdepartment name
Sample Data Tables
tableEMPLOYEESEMPLOYEEIDEMPLOYEENAME,SALARY,DEPARTMENTNAMEDylan Becker,ITGiovanny Keith,ITSkyler Luna,ITKaiya Everett,SALES
Sample Output
Total Salaries Before Increment
Total Salaries After Increment
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
