--zad1
/*declare v_max_id employees.employee_id%type;
begin
select max(employee_id) into v_max_id from employees;
dbms_output.put_line(v_max_id);
end; */

/*--zad2
declare v_max_id employees.employee_id%type;
begin
select max(employee_id)+1 into v_max_id from employees;
dbms_output.put_line(v_max_id);
insert into employees (employee_id, last_name, email, hire_date,job_id)  values (v_max_id,'Kowalski','kowal@op.pl', to_date('04-04-2014','dd-mm-yyyy'),'IT_PROG');
end;
*/
--zad3
declare v_dolna employees.salary%type := &dolna;
v_gorna employees.salary%type := &gorna;
v_id_od employees.department_id%type :=50;
cursor kursor is select first_name, last_name,salary from employees where department_id = v_id_od;
begin

for rekord in kursor loop
if rekord.salary > v_dolna
and rekord.salary < v_gorna then
dbms_output.put_line  (rekord.first_name || ' ' || rekord.last_name);
end if;
end loop;
end;