Insert View « View « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. View
  3. Insert View
8.2.Insert View
8.2.1.Performing an INSERT Using a View
8.2.2.Because employee_view didn't use WITH CHECK OPTION, you can insert, update, and delete rows that aren't retrievable by the subquery.
8.2.3.ORA-01402: view WITH CHECK OPTION where-clause violation