ALL_NOTIFICATION_DIRECTIVES

ALL_NOTIFICATION_DIRECTIVES describes the notification directives accessible to the current user.

You can join this view with the ALL_DIRECTIVES view to obtain additional details about notification directives.

DBA_NOTIFICATION_DIRECTIVES describes all notification directives in the database.
USER_NOTIFICATION_DIRECTIVES describes the notification directives owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the notification directive
`DIRECTIVE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the notification directive
`NOTIFICATION_TABLE`	`VARCHAR2(128)`	`NOT NULL`	Notification table that tracks changes to the object
`NOTIFICATION_VIEW`	`VARCHAR2(128)`	`NOT NULL`	Notification view that tracks changes to the object
`RETENTION`	`VARCHAR2(20)`		Retention of the notification directive as specified in the `CREATE` `DIRECTIVE` DDL statement
`NOTIFICATION_COLUMNS_CLAUSE`	`VARCHAR2(32767)`		Columns clause of the notification directive
`INCLUDING_OLD_VALUES`	`VARCHAR2(5)`		Indicates whether old values are included (`TRUE`) or not (`FALSE`)

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.4.

See Also:

Related Views