PrintReport

CREATE OR REPLACE
PROCEDURE PrintReport
AS
v_count INT := 0;
BEGIN
  FOR depart IN (SELECT * FROM Department)
    loop
      SELECT COUNT(*) INTO v_count FROM Teacher WHERE department = depart.u_id;
      IF (v_count > 0) THEN
        dbms_output.put_line('');
        dbms_output.put_line('ID katedry: ' || depart.u_id);
        dbms_output.put_line('Nazov kadedry: ' || depart.name);
        dbms_output.put_line('Pocet zamestnancov: ' || v_count);
        FOR head IN (SELECT * FROM Teacher WHERE department = depart.u_id)
          LOOP
            IF (head.login = depart.head) THEN
              dbms_output.put_line('Veduci katedry: ' || head.login);
              exit;
            ELSE
              dbms_output.put_line('Nema veduceho');
            END IF;
          END LOOP;
        dbms_output.put_line('');
        dbms_output.put_line('Zamestnanci: ');
        FOR teach IN (SELECT * FROM Teacher WHERE department = depart.u_id)
         loop
          IF (teach.login <> depart.head OR depart.head IS NULL) THEN
            dbms_output.put_line('login: ' || teach.login);
            dbms_output.put_line('fname: ' || teach.fname);
            dbms_output.put_line('lname: ' || teach.lname);
            dbms_output.put_line('email: ' || teach.email);
            dbms_output.put_line('');
          END IF;
         END loop;
       END IF;
    END loop;
END;