SQL Tutorial : SIMPLE VIEW

SQL Tutorial : SIMPLE VIEW

Let's learn about next topic: SIMPLE VIEW

CREATING SIMPLE VIEW:

-CREATE OR REPLACE  VIEW EMPV

AS

SELECT EMPLOYEE_ID EID ,LAST_NAME LNAME ,SALARY SAL

FROM COPY_EMP

WHERE DEPARTMENT_ID= 50

- INSERT INTO EMPV

VALUES

(210,'WIPRO',20000,'SA_REP')

- CREATE OR REPLACE  VIEW EMPV

AS

SELECT EMPLOYEE_ID EID ,LAST_NAME LNAME ,SALARY SAL

FROM COPY_EMP

WITH READ ONLY

- CREATE OR REPLACE  VIEW EMPV

AS

SELECT EMPLOYEE_ID EID ,LAST_NAME LNAME ,SALARY SAL ,JOB_ID

FROM COPY_EMP

WHERE SALARY >5000

WITH CHECK OPTION

- CREATE OR REPLACE FORCE VIEW EEVV

AS SELECT LNAME ,LSAL

FROM LTABLE

DD: USER_VIEWS

- SELECT VIEW_NAME

FROM USER_VIEWS

WHERE VIEW_NAME LIKE'EE%'