set serveroutput on
DECLARE
	v_employee_id employees.employee_id%TYPE;
	v_last_name employees.last_name%TYPE;
	v_first_name employees.first_name%TYPE;
	v_department_name departments.department_name%TYPE;
	v_salary employees.salary%TYPE;
    v_salary1 employees.salary%TYPE;


	CURSOR v_podwyzka_cursor IS
		SELECT employee_id, last_name, first_name, department_name, salary
		FROM employees
		JOIN departments using(department_id);
BEGIN
	OPEN v_podwyzka_cursor;
	LOOP
		FETCH v_podwyzka_cursor
		INTO v_employee_id, v_last_name, v_first_name, v_department_name, v_salary;
		EXIT WHEN v_podwyzka_cursor%NOTFOUND;
        if v_salary > 6000 then
            DBMS_OUTPUT.PUT_LINE(v_employee_id || ' ' || v_last_name || ' ' || v_first_name || ' ' || v_department_name || ' ' || v_salary || ' - podwyzka brak');
        ELSIF v_salary <= 6000 then
            v_salary1 := (v_salary*1.2)-v_salary;
            DBMS_OUTPUT.PUT_LINE(v_employee_id || ' ' || v_last_name || ' ' || v_first_name || ' ' || v_department_name || ' ' || v_salary || ' - podwyzka ' || v_salary1);
        END IF;
	END LOOP;
	CLOSE v_podwyzka_cursor;
END;