11.Vederi

1. CREATE OR REPLACE VIEW EMPLOYEE
AS SELECT EMPNO, ENAME ANGAJAT, DEPTNO
  FROM EMP;
Pentru a vizualiza continutul vederii se foloseste SELECT * FROM EMPLOYEE;

2. CREATE OR REPLACE VIEW INFO_DEPT
    (DEPTNO, MEDIA, MAXIM, MINIM, SUMA, NO_SAL, NO_COM)
  AS SELECT DEPTNO, AVG(SAL), MAX(SAL), MIN(SAL), SUM(SAL), COUNT(SAL), COUNT(COMM)
    GROUP BY DEPTNO;

3.CREATE OR REPLACE VIEW DEPT20
    (COD, PERSOANA, DEPTNO)
  AS SELECT EMPNO, ENAME, DEPTNO
  FROM EMP
  WHERE DEPTNO=20
  WITH CHECK OPTION CONSTRAINT depart20;

SELECT * FROM DEPT20;

UPDATE DEPT20
SET DEPTNO=10
WHERE EMPNO=7902;