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