SET SERVEROUTPUT ON
DECLARE
CURSOR kursor1 IS SELECT LAST_NAME, HIRE_DATE, JOB_ID FROM EMPLOYEES WHERE JOB_ID = 'AC_MGR' OR JOB_ID = 'SA_MAN' OR JOB_ID = 'ST_MAN' OR JOB_ID = 'MK_MAN';
v_nazwisko VARCHAR2(25);
v_stanowisko VARCHAR2(10);
v_data DATE;
BEGIN
OPEN kursor1;
FETCH kursor1 INTO v_nazwisko, v_data, v_stanowisko;
DBMS_OUTPUT.put_line(v_stanowisko || ' ' ||  v_nazwisko || ' pracuje od ' || TO_CHAR(v_data));
CLOSE kursor1;
END;