PRINTREPORT

CREATE OR REPLACE
PROCEDURE PrintReport
AS

counter INT;
CURSOR dep IS SELECT * FROM Department;
CURSOR tch IS SELECT * FROM Teacher;
BEGIN


  FOR cursdep IN dep LOOP
  SELECT COUNT(*) INTO counter FROM Teacher WHERE department = cursdep.id;
  DBMS_OUTPUT.PUT_LINE('ID: ' || cursdep.id || ' NAME: ' || cursdep.name || ' HEAD: ' || cursdep.head || ' NUMBER OF TEACHERS: ' || counter);
    FOR curstch IN tch LOOP
      IF cursdep.head <> curstch.login AND curstch.department = cursdep.id THEN
        DBMS_OUTPUT.PUT_LINE('---- LOGIN: ' || curstch.login || ' FNAME: ' || curstch.fname || ' LNAME: ' || curstch.lname || ' EMAIL: ' || curstch.email);
      END IF;
    END LOOP;
  END LOOP;
END;