Retrieving Information on View Constraints

The user_constraints view has information on view constraints.



SQL> SELECT constraint_name,
  2         constraint_type,
  3         status,
  4         deferrable,
  5         deferred
  6  FROM user_constraints
  7  WHERE table_name IN ('EMP_VIEW')
  8  ORDER BY constraint_name;

CONSTRAINT_NAME                C STATUS   DEFERRABLE     DEFERRED
------------------------------ - -------- -------------- ---------
EMP_READ_ONLY                  O ENABLED  NOT DEFERRABLE IMMEDIATE

SQL>
Home »
Oracle »
Table » 

Views:
  1. Creating and Using a View
  2. Creating and Using Simple Views
  3. Performing an INSERT Using a View
  4. A View with a CHECK OPTION Constraint
  5. View with a READ ONLY Constraint
  6. Getting Information on View Definitions with DESCRIBE command
  7. Getting Information on View Definitions with user_views view
  8. Retrieving Information on View Constraints
  9. Creating and Using Complex Views
  10. Modifying a View
  11. Alter the constraints on a view using ALTER VIEW
  12. Dropping a View
Related: