bd lab 17.12.2018 incomplet

--lab 8
--ex2

insert into ANGAJATI_CPI(cod_ang,nume,prenume,job,salariu,cod_dep)
values(101,'nume2','prenume2',to_date('02-02-2004','dd-mm-yyyy'),'inginer',10000,10);

insert into angajati_cpi
values (101,'nume2','prenume2','nume2',to_date('02-02-2004','dd-mm-yyyy'),'inginer',100,1000,10);

insert into angajati_cpi
values (102, 'nume5', 'prenume5', 'nume5', null, 'analist', 101,3000,30);

commit;

alter table angajati_cpi
add constraint cod_ang_pk_cpi primary key(cod_ang);

alter table angajati_cpi
add constraint nume_not_null_cpi CHECK(nume is not null);

alter table angajati_cpi
add constraint salariu_not_null_cpi check(salariu is not null);

--3
create table angajati10_cpi as
select *
from angajati_cpi
where cod_dep = 10;

--4
alter table angajati_cpi
add comision number(4,2);

--5
alter table angajati_cpi
modify comision number(6,7);

--6
alter table angajati_cpi
modify salariu number(9,2) default -4;

--7
alter table angajati_cpi
modify (salariu number(10,2), comision number(2,2));

--8
update angajati_cpi
set comision = 0.1
where lower(job) like 'a%';

--9
alter table angajati_cpi
modify email varchar2(15);

--10
alter table angajati_cpi
add nr_telefon varchar2(15);

--11
select *
from angajati_cpi;

alter table angajati_cpi
drop column nr_telefon;

--12
rename angajati_cpi to angajati3_cpi;

--13
select *
from tab
rename angajati13_cpi to angajati_cpi;

--14
truncate table angajati110_cpi;

--15
create table DEPARTAMENTE_CPI (
    cod_dep number(2),
    nume varchar2(15) constraint nume_not_null_dep_cpi not null,
    cod_director number(4));
desc departmanete_cpi;

--16
insert into departamente_cpi
values(10,'Administrativ', 100);
insert into departamente_cpi
values (20,'Proiectare',101);
insert into departamente_cpi
values (10,'Programare',null);

--17
alter table departamente_cpi
add constraint cod_dep_pk_cpi primary key(cod_dep);

--18
alter table angajati_cpi
add constraint fk_cod_dep_cpi foreign key(cod_dep)
references departamente_cpi(cod_dep);

--21
drop table departamente_cpi;

--22
desc user_constraints;

select * from user_tables
where lower(table_name) = 'angajati_aga';

select constraint_name, constraint_type, table_name
from user_connstraints
where lower(table_name) in ('angajati_aga', 'departamente_aga');

--24
alter table angajati_cpi
add constraint email_not_null_cpi check(email is not null);

update angajati_cpi
set email;

--25
inert into departamente_cpi
values (80, 'Analiza', null);
commit;

--27
delete from departamente_cpi
where cod_dep = 20;

--24