336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
CREATE OR REPLACE VIEW empvu20
AS
SELECT *
FROM employees WHERE department_id = 20
WITH CHECK OPTION CONSTRAINT empvu20_ck;
AS
SELECT *
FROM employees WHERE department_id = 20
WITH CHECK OPTION CONSTRAINT empvu20_ck;
No rows are updated because if the department number were to change to 10, the view would no longer be able to see that employee. With the WITH CHECK OPTION clause, therefore, the view can see only employees in department 20 and doesn't allow the department number for those employees to be changed through the view.
'Oracle' 카테고리의 다른 글
| Denying DML Operations & Removing a View (0) | 2006.11.24 |
|---|---|
| Denying DML Operations & Removing a View (0) | 2006.11.24 |
| Using the WITH CHECK OPTION Clause (0) | 2006.11.24 |
| Rules for Performing DML Operations on a View (0) | 2006.11.24 |
| Rules for Performing DML Operations on a View (0) | 2006.11.24 |