Question: 3 . PLSQL - Employees not assigned to any Department Write a PLSQL block which should assign department _ id and department _ manager to
PLSQL Employees not assigned to any Department
Write a PLSQL block which should assign departmentid and departmentmanager 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 assignedupdated records with other employee details.
Schema tables are given below
Output format should be as below:
Empid Empname Empstatus Deptid Deptname Mgrname
jonny Dsouza Active Internal Services Mildred Viola
Empname and Mgrname should contain the firstname and lastname separated by space.
Note: Add SET SERVEROUTPUT ON; at the beginning and at the end of the PLSQL Block.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
