manager_id integer location_id integer PL/SQL Code: DECLARECURSORdpt_curISSELECTd.department_id id,department_name name,Nvl(first_name,' ')managerFROMdepartments dleftouterjoinemployees eON(d.manager_id=e.employee_id);emp_count NUMBER(3);job_hist_count NUMBER(3);BEGINFORdept_allINdpt_curLOOP...
department_name varchar(25) manager_id integer location_id integer PL/SQL Code: DECLARECURSORemp_dep_curISSELECTdepartment_name,manager_idFROMdepartments;emp_manager employees.first_name%TYPE;BEGINdbms_output.Put_line(Rpad('Department',30)||Rpad('Department Head',30));dbms_output.Put_line('---...
Economic Affairs Department, Hagos Gebrehiwot (also known as Hagos “Kisha”).309 In January 2011, however, the Manager of the Commercial Bank of Eritrea told the Monitoring Group that the board had not met since 2009, and that decisions concerning the allocation of hard currency resources were...
Contribute your code (and comments) through Disqus.Previous SQL Exercise: Employees including the first name of their manager. Next SQL Exercise: Display employees who have or have not any department.What is the difficulty level of this exercise? Easy Medium Hard ...