Notes

declare
pete_id employees.employee_id%type;
pete_gehalt employees.salary%type;
pete_com employees.commission_pct%type;
pete_hiredate employees.hire_date%type;
comm employees.commission_pct%type;
begin
-- getting pete's id
select employee_id into pete_id from employees where first_name = 'Peter' and last_name = 'Tucker';
dbms_output.put_line(pete_id);
-- getting pete's salary + you can change and test what salary he should have!
--update employees set salary = 1000 where employee_id = pete_id;
select salary into pete_gehalt from employees where employee_id = pete_id;
dbms_output.put_line(pete_gehalt);
-- getting pete's hire date
select hire_date into pete_hiredate from employees where employee_id = pete_id;

if pete_gehalt < 10000 then pete_com := 0.4;
elsif pete_gehalt > 10000 and (sysdate-pete_hiredate)/365>10 then pete_com := 0.35;
elsif pete_gehalt < 3000 then pete_com := 0.25;
else pete_com := 0.15;
end if;

update employees set commission_pct = pete_com where employee_id = pete_id;
select commission_pct into comm from employees where employee_id = pete_id;
dbms_output.put_line(comm);
end;
rollback;