eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_APPLY_ENQUEUE

Object Details

Object Name:	ALL_APPLY_ENQUEUE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_OWNER	VARCHAR2	(128)	Yes	Owner of the rule
RULE_NAME	VARCHAR2	(128)	Yes	Name of the rule
DESTINATION_QUEUE_NAME	VARCHAR2	(4000)		Name of the queue where events satisfying the rule will be enqueued

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_OWNER
,      RULE_NAME
,      DESTINATION_QUEUE_NAME
FROM SYS.ALL_APPLY_ENQUEUE;

Dependencies

[top of page]

SYS.ALL_APPLY_ENQUEUE references the following:

SYS: ALL_QUEUES; ALL_RULES; ANYDATA; DBA_APPLY_ENQUEUE; RE$NV_ARRAY

SYS.ALL_APPLY_ENQUEUE is referenced by following:

PUBLIC: ALL_APPLY_ENQUEUE