Data Dictionary Views for Listing Directives

Oracle AI Database provides static data dictionary views to list directives.

General directive views:
  • DBA_DIRECTIVES - all directives
  • ALL_DIRECTIVES - directives accessible to the current user
  • USER_DIRECTIVES - directives owned by the current user
Validation-specific directive views:
  • DBA_VALIDATION_DIRECTIVES
  • ALL_VALIDATION_DIRECTIVES
  • USER_VALIDATION_DIRECTIVES