Data Dictionary Views for Listing Notification Directives
Oracle AI Database provides static data dictionary views to list directives.
General directive views:
DBA_DIRECTIVES- all directivesALL_DIRECTIVES- directives accessible to the current userUSER_DIRECTIVES- directives owned by the current user
Notification-specific directive views:
DBA_NOTIFICATION_DIRECTIVESALL_NOTIFICATION_DIRECTIVESUSER_NOTIFICATION_DIRECTIVES