set serveroutput on; declare act number; ter number; mgrname varchar$2(200)$; mgr$\_$sup varchar$2(200)$; superv varchar$2(200)$; cursor curr is select emp$\_$id$,$ concat$($emp$\_$fname,concat$(\text{'}\text{'},$emp$\_$lname$))$ as empname, emp$\_$status from emp; cursor curr$2$ is select superv, concat$($e$.$emp$\_$fname,concat$(\text{'}\text{'},$e$.$emp$\_$lname$))$ as mgrname, e$.$emp$\_$status as stat, e$.$mgr$\_$id as mgr$1$ from emp e$,$ emp a where a$.$mgr$\_$id$=$e$.$emp$\_$id; c$1$ curr$\%$rowtype; c$2$ curr$2\%$rowtype; begin select count$($emp$\_$id$)$ into act from emp where emp$\_$status$=$'Active'; select count$($emp$\_$id$)$ into ter from emp where emp$\_$status$=$'Terminated'; dbms$\_$output.put$\_$line$(\text{'}**$Status Count$**\text{'})$; dbms$\_$output.put$\_$line$(\text{'}$Active $\text{'}||\text{'}\text{'}||$act$)$; dbms$\_$output.put$\_$line$(\text{'}$Terminated $\text{'}||\text{'}\text{'}||$ter$)$; dbms$\_$output.put$\_$line$(\text{'}**$Employees under Terminated Manager$**\text{'})$; dbms$\_$output.put$\_$line$(\text{'}$emp$\_$id emp$\_$name Mgr$\_$name Mgr$\_$Status Mgr$\_$Supervisor'$)$; open curr; open curr$2$;

loop fetch curr into c$1$; fetch curr$2$ into c$2$; exit when curr$\%$notfound; if c$2.$stat$=$'Terminated' and c$1.$emp$\_$status$=$'Active' then select concat$($emp$\_$fname,concat$(\text{'}\text{'},$emp$\_$lname$))$ into superv from emp where

emp$\_$id$=$c$2.$mgr$1$; dbms$\_$output.put$\_$line$($c$1.$emp$\_$id$||\text{'}\text{'}||$c$1.$empname$||\text{'}\text{'}||$c$2.$mgrname$||\text{'}\text{'}||$ c$2.$stat$||\text{'}\text{'}||$superv$)$; end if; end loop; end;

Display the expected output