-- ZAD[02]
DECLARE

  data_od DATE;
  data_do DATE;
  X INT;

BEGIN

data_od := TO_DATE('&data_od','YYYY.MM.DD');
data_do := TO_DATE('&data_do','YYYY.MM.DD');

SELECT COUNT(*)
INTO X
FROM (
SELECT * FROM NOWI_EMPLOY
WHERE HIRE_DATE > data_od
AND HIRE_DATE   < data_do);
DBMS_OUTPUT.PUT_LINE('LICZBA PRACOWNIKOW OD ' || TO_CHAR(data_od) || ' DO ' || TO_CHAR(data_do) || ' wynosi: ' || TO_CHAR(x));

END;