muiePSD

ALTER TABLE employeeskit ADD CONSTRAINT id_departmentt FOREIGN KEY (id_department) REFERENCES departmentsweb(id_department);
ALTER TABLE employeeskit ADD CONSTRAINT salary_nn CHECK(salary IS NOT NULL);
DESC employeeskit;
ALTER TABLE employeeskit MODIFY salary NUMBER(5);
SELECT * FROM employeeskit;

ALTER TABLE employeeskit ADD salary NUMBER(6);

CREATE TABLE carsweb ( id_emp NUMBER(2) CONSTRAINT id_emp_fk REFERENCES employeeskit(id_emp),
valoare NUMBER(6) CONSTRAINT valoare_nn CHECK(valoare IS NOT NULL));
DESC carsweb;

ALTER TABLE carsweb ADD ( sh_val NUMBER(5));

ALTER TABLE carsweb DROP COLUMN sh_val;

DROP TABLE carsweb;
DESC departmentsweb;

ALTER TABLE departmentsweb MODIFY (department_location VARCHAR2(20), department_email VARCHAR2(30), department_name VARCHAR2(30));
ALTER TABLE departmentsweb MODIFY (DEPARTMENT_WORKHOURS_S VARCHAR(20),DEPARTMENT_WORKHOURS_f VARCHAR(20));

INSERT INTO departmentsweb VALUES (10,'HR','Victoriei','hr@gmail.com',0721615779,'Emil Gheorghe','10:30:00','16:30:00');
INSERT INTO departmentsweb VALUES (11,'PR','Victoriei','pr@gmail.com',0721615779,'Gina Enache','10:30:00','16:30:00');
INSERT INTO departmentsweb VALUES (12,'ITfront','Victoriei','itfront@gmail.com',0721615779,'Paris Iannis','10:30:00','16:30:00');
INSERT INTO departmentsweb VALUES (13,'ITback','Victoriei','itback@gmail.com',0721615779,'Niculae Bogdan','10:30:00','16:30:00');

SELECT * FROM departmentsweb;
SELECT * FROM employeeskit;



INSERT INTO employeeskit VALUES(2,12 ,'Iannis','Paris',0721615778,'Ana Ipatescu 12',6000);
INSERT INTO employeeskit VALUES(3,13,'Bogdan','Niculae',0721615771,'Calea Grivitei 81',3450);
INSERT INTO employeeskit VALUES(5,11,'Gina','Enache',0721615775,'Drumul Taberei 72',2200);
INSERT INTO employeeskit VALUES(4,10,'Emil','Gheorghe',0721615777,'Dorobantilor 22',1890);

DESC customersweb;
ALTER TABLE customersweb ADD id_order NUMBER(2,0);
ALTER TABLE customersweb ADD CONSTRAINT id_order FOREIGN KEY (id_order) REFERENCES ordersweb(id_order);

INSERT INTO customersweb VALUES(91,'Ion','Popa','Grivita','ion@gmail.com',0721615122,TO_DATE('17/12/2015', 'DD/MM/YYYY'),42);
INSERT INTO customersweb VALUES(92,'Doru','Lungoci','Dorobanti','doru@gmail.com',0721615122,TO_DATE('02/12/2016', 'DD/MM/YYYY'),51);
INSERT INTO customersweb VALUES(93,'Mihai','Dabuleanu','Unirii','mihai@gmail.com',0721615122,TO_DATE('30/10/2017', 'DD/MM/YYYY'),71);
INSERT INTO customersweb VALUES(94,'Ionel','Petrisor','Basarab','ionel@gmail.com',0721615122,TO_DATE('21/4/2017', 'DD/MM/YYYY'),58);

DESC discountweb;
CREATE TABLE discountweb (id_discount NUMBER(2,0) PRIMARY KEY, discount_description VARCHAR2(10), discount_percent NUMBER(2,2));
CREATE TABLE servicesweb (id_services NUMBER(2,0) PRIMARY KEY, service_name VARCHAR2(10), service_price INTEGER, service_quantity NUMBER(2,0), service_status VARCHAR2(10));
ALTER TABLE discountweb MODIFY (discount_description VARCHAR2(30), DISCOUNT_PERCENT NUMBER(2));
INSERT INTO discountweb VALUES(41,'Christmas sales',10);
INSERT INTO discountweb VALUES(42,'Winter sales',15);
INSERT INTO discountweb VALUES(43,'Easter sales',10);
INSERT INTO discountweb VALUES(44,'BlackFriday sales',35);

INSERT INTO servicesweb VALUES(1,'Hosting',150,1,'OK');
INSERT INTO servicesweb VALUES(2,'Hosting+',450,1,'FULL');
INSERT INTO servicesweb VALUES(3,'WebforYou',1500,1,'OK');
INSERT INTO servicesweb VALUES(4,'Care+',550,1,'NA');