Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department_id= 90 (there is suppose to be 3 employee who work in Department 90) IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first_name , salary of each employee and store them in local variables. SELECT LOAD INTO v_firstname1, v_salary1 WHERE employee_id=100 Then second SELECT first_name, salary INTO v_firstname2, v_salary2 ….. WHERE employee_id=101 Then third SELECT, SELECT first_name, salary INTO v_firstname3, v_salary3 ….. WHERE employee_id=102 You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END.
Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department_id= 90 (there is suppose to be 3 employee who work in Department 90)
IN BEGIN END END SECTION;
Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first_name , salary of each employee and store them in local variables.
SELECT LOAD INTO v_firstname1, v_salary1 WHERE employee_id=100
Then second
SELECT first_name, salary INTO v_firstname2, v_salary2 ….. WHERE employee_id=101
Then third
SELECT, SELECT first_name, salary INTO v_firstname3, v_salary3 ….. WHERE employee_id=102
You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END.
Then add another SELECT statement in BEGIN-END to find company average salary
SELECT avg(salary) INTO v_avgsal FROM EMPLOYEES;
!!! Do not forget to create v_avgsal local variable in DECLARE section.
Step by step
Solved in 2 steps