CREATE OR REPLACE VIEW EMPLOYEES_VU
AS SELECT EMPLOYEE_ID, LAST_NAME EMPLOYEE, DEPARTMENT_ID
FROM EMPLOYEES;

SELECT* FROM EMPLOYEES_VU;

SELECT EMPLOYEE,DEPARTMENT_ID FROM EMPLOYEES_VU;

CREATE OR REPLACE VIEW DEPT50
AS SELECT EMPLOYEE_ID EMPNO, LAST_NAME EMPLOYEE, DEPARTMENT_ID DEPTNO
FROM EMPLOYEES
WHERE DEPARTMENT_ID = 50
WITH CHECK OPTION CONSTRAINT EMP_DEPT_50;

DESC DEPT50
SELECT * FROM DEPT50;

UPDATE DEPT50
SET DEPTNO = 80
WHERE EMPLOYEE = 'Matos';

CREATE SEQUENCE DEPT_ID_SEQ
INCREMENT BY 10
START WITH 200
MAXVALUE 1000;

INSERT INTO DEPT
VALUES (DEPT_SEQ_ID.NEXTVAL, 'EDUCATION')

INSERT INTO DEPT
VALUES (DEPT_SEQ_ID.NEXTVAL, '