Description: The "WITH CHECK OPTION" is used to indicate that Oracle will prevent any changes to the table or view that would produce rows that are not included in the subquery. When used in the subquery of a DML statement, you can specify this clause in a subquery in the FROM clause but not in subquery in the WHERE clause.
Language: PL/SQL Highlight Mode: SQL Last Modified: March 04th, 2009
--The following statement is legal even though -- the third value inserted violates the condition -- of the subquery where_clause:INSERTINTO(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:INSERTINTO(SELECT department_id, department_name, location_id
FROM departments WHERE location_id <2000WITHCHECKOPTION)VALUES(9999,'Entertainment',2500);
ERROR at line 2:
ORA-01402: VIEWWITHCHECKOPTION where-clause violation
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.