DECLARE
  CURSOR kursor IS
    SELECT e.last_name, j.job_title
    FROM employees e JOIN jobs j ON e.job_id = j.job_id;
BEGIN
  FOR rekord IN kursor LOOP
    DBMS_OUTPUT.PUT_LINE('Pracownik ' || rekord.last_name || ' pracuje na stanowisku ' || rekord.job_title);
  END LOOP;
END;
/