Exercise 6

Create a PL/SQL block that will prompt the user to input department number and then displays the relevant information about the department. Refer to the sample output given below:

Enter value for department: 10 Department 10 (Accounting) is in New York has 3 employee(s) with total salary R8750.00

Enter value for department: 20 Department 20 (Research) is in Dallas has 5 employee(s) with total salary R10875.00

Enter value for department: 40 Department 40 (Operations) is in Boston has 0 employee(s) with total salary R0.00