PL/SQL Control Statement Exercises: Count the number of employees in department 50 and check whether this department have any vacancies or not. There are 45 vacancies in this department
PL/SQL Control Statement: Exercise-7 with Solution
Write a PL/SQL program to count the number of employees in department 50 and check whether this department have any vacancies or not. There are 45 vacancies in this department.
SET SERVEROUTPUT ON DECLARE tot_emp NUMBER; BEGIN SELECT Count(*) INTO tot_emp FROM employees e join departments d ON e.department_id = d.department_id WHERE e.department_id = 50; dbms_output.Put_line ('The employees are in the department 50: ' ||To_char(tot_emp)); IF tot_emp >= 45 THEN dbms_output.Put_line ('There are no vacancies in the department 50.'); ELSE dbms_output.Put_line ('There are some vacancies in department 50.'); END IF; END; /
The employees are in the department 50: 45 There are no vacancies in the department 50. PL/SQL procedure successfully completed.
Improve this sample solution and post your code through Disqus
What is the difficulty level of this exercise?
- New Content published on w3resource:
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework