CREATE TABLE EMP5 AS
SELECT employee_id, last_name, salary
FROM employees;

CREATE UNIQUE INDEX emp_ix
ON EMP5(employee_id);

select * from emps;

CREATE TABLE JOB5 AS
SELECT JOB_ID, JOB_TITLE
FROM jobs;

CREATE UNIQUE INDEX job_ix
ON JOB5(job_id);

select * from jobs;

--za2
update employees set salary = salary
+ 1000 where last_name='King';
savepoint SP1;
update employees set salary = salary
+ (salary * 0.1) where last_name='Tucker';
savepoint SP2;
delete from employees where last_name
='Nayer';

rollback to SP1;
rollback to SP2;
select * from employees;
--za3

delete from employees where last_name
='Nayer';
savepoint SP3;
alter table JOB5
modify JOB_TITLE varchar2(8);
rollback to SP3;
-- Wyrzucenie wyjatku przez
-- probe zmiany typu kolumny spowodowalo
-- usuniecie savepointu, przez co nie da sie
-- cofnac do niego
--zad4
create or replace procedure zad54(id_ number,
first_name_ varchar2,
last_name_ varchar2
)
as
ilosc number;
begin
savepoint temp;
insert into emp5 values(id_, last_name_, 9999);
select count(*)   into ilosc from emp5 where last_name = last_name_;
if(ilosc >= 2)
then
rollback to temp;
end if;
end;