Question: Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees in the department and how many employees need

Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees in the

Department 10 typically has 50 employees. a PL/SQL program to count the number of current employees in the department and how many employees need to be hired to bring the count to 50. Your solution MUST: (1) Declare a variable to hold the count of current employees (v_num_empl), a variable to hold the number to be hired (v_num_hire), and a constant to store the value 50 (c_max_empl). (2) Retrieve the count of employees currently in department 10. (3) Compute the difference using c_max_empl and v_num_empl and store the result in v_num_hire. (4) Display the current number of employees and the number of new hires needed. Include appropriate labels for the output. Use the employees table. Output: the current number of employees is 4 the number to hire is 46.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Here is a PLSQL program that counts the number of current employees in department 10 ... View full answer

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!