--The following statement is legal even though
-- the third value inserted violates the condition
-- of the subquery where_clause:
INSERT INTO (SELECT department_id, department_name, location_id
FROM departments WHERE location_id < 2000)
VALUES (9999, 'Entertainment', 2500);
-- However, the following statement is illegal because it contains
-- the WITH CHECK OPTION clause:
INSERT INTO (SELECT department_id, department_name, location_id
FROM departments WHERE location_id < 2000 WITH CHECK OPTION)
VALUES (9999, 'Entertainment', 2500);
*
ERROR at line 2:
ORA-01402: VIEW WITH CHECK OPTION where-clause violation