DELETE FROM EMPLOYEES_TEST WHERE PHONE_NUMBER LIKE '%590%';
UPDATE EMPLOYEES_TEST SET SALARY = '30000'
WHERE PHONE_NUMBER LIKE '%23%';
UPDATE EMPLOYEES_TEST SET COMMISSION_PCT = '0,2'
WHERE MANAGER_ID = '103';
INSERT INTO EMPLOYEES_TEST (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID,BONUS) VALUES ('300','Nabil','Safwah','NSAFWAH','720.863.0485',TO_DATE('26.01.01','DD.MM.RR'),'MK_REP','5000',NULL,'201','20',NULL);
INSERT INTO EMPLOYEES_TEST (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID,BONUS) VALUES ('310','Jelena','Duric','JDURIC','505.514.1583',TO_DATE('21.05.03','DD.MM.RR'),'AC_ACCOUNT','6400',NULL,'205','110',NULL);
INSERT INTO EMPLOYEES_TEST (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID,BONUS) VALUES ('320','Jennifer','Loermans','JLOERMANS','213.447.9053',TO_DATE('24.04.03','DD.MM.RR'),'AC_ACCOUNT','7200',NULL,'205','110',NULL);
COMMIT;