DAIS_4

CREATE OR REPLACE
PROCEDURE PocetJizd
AS
CURSOR cursStaff IS SELECT * FROM Staff;
counter INT;
BEGIN
  FOR cStaff IN cursStaff LOOP
    SELECT COUNT(*) INTO counter FROM TrainCrew WHERE idStaff = cStaff.idStaff;
  DBMS_OUTPUT.PUT_LINE('NAME: ' || cStaff.fname || ' LNAME: ' || cStaff.lname || ' COUNTER: ' || counter);
  END LOOP;
END;