12일차 # 10-13: Cannot Remove a Row on Complex View

  

Cannot Remove a Row on Complex View

        = Complex View에 Delete DML을 사용할 수 없는 경우

       그. 디(대). 로

  SQL> create or replace view test_vu

       as select distinct deptno

       from emp;

View created.

  SQL> select * from test_vu;

   DEPTNO

----------

       30

       20

       10

  SQL> delete from test_vu

       where deptno = 10;

delete from test_vu

           *

ERROR at line 1:

ORA-01732: data manipulation operation not legal on this view