Oracle/SQL Fundamentals I

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

Bohemian life 2012. 4. 19. 15:16
  

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