SET SERVEROUTPUT ON;
DECLARE
CURSOR zadanie6 IS
SELECT e.last_name, e.salary, j.job_title
FROM employees e
JOIN jobs j ON e.job_id = j.job_id
WHERE e.employee_id IN (SELECT manager_id FROM employees) OR j.job_title LIKE '% Manager';
v_last_name employees.last_name%TYPE;
v_salary employees.salary%TYPE;
v_job_title jobs.job_title%TYPE;
BEGIN
OPEN zadanie6;
LOOP
FETCH zadanie6 INTO v_last_name, v_salary, v_job_title;
EXIT WHEN zadanie6%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(v_last_name || ', ' || v_salary || ', ' || v_job_title);
END LOOP;
CLOSE zadanie6;
END;
Paste Hosted With By Wklejamy.pl