Question: 3 . PLSQL - Employees not assigned to any Department Write a PLSQL block which should assign department _ id and department _ manager to

3. PLSQL - Employees not assigned to any Department
Write a PLSQL block which should assign department_id and department_manager to the Active employees who does not belong to any department.
Department which you assign to the Active employees should not have any employees tagged to it. Display the newly assigned/updated records with other employee details.
Schema tables are given below
Output format should be as below:-
Emp_id Emp_name Emp_status Dept_id Dept_name Mgr_name
1 jonny Dsouza Active 11 Internal Services Mildred Viola
Emp_name and Mgr_name should contain the first_name and last_name separated by space.
Note: Add SET SERVEROUTPUT ON; at the beginning and / at the end of the PLSQL Block.
3 . PLSQL - Employees not assigned to any

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Programming Questions!