حل تمارين الدرس الحادى عشر

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 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;

DESCRIBE dept50

SELECT *
FROM dept50;

UPDATE dept50
SET deptno = 80
WHERE employee = 'Matos';

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

INSERT INTO dept
VALUES (dept_id_seq.nextval, 'Education');

INSERT INTO dept
VALUES (dept_id_seq.nextval, 'Administration');

CREATE INDEX dept_name_idx ON dept (name);

CREATE SYNONYM emp FOR EMPLOYEES;