[Home] [Help]
[Dependency Information]
VIEW: SYS.USER_CQ_NOTIFICATION_QUERIES
Object Details
Object Name: | USER_CQ_NOTIFICATION_QUERIES |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of registered queries for CQ notification
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
QUERYID |
NUMBER |
|
|
queryid of the query |
QUERYTEXT |
CLOB |
(4000) |
|
querytext of the query |
REGID |
NUMBER |
|
|
Registration Id which the query is registered with |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT QUERYID
, QUERYTEXT
, REGID
FROM SYS.USER_CQ_NOTIFICATION_QUERIES;
Dependencies
[top of page]
SYS.USER_CQ_NOTIFICATION_QUERIES references the following:
-
SYS
-
DBA_CQ_NOTIFICATION_QUERIES
-
USER_CHANGE_NOTIFICATION_REGS
SYS.USER_CQ_NOTIFICATION_QUERIES is referenced by following:
-
PUBLIC
-
USER_CQ_NOTIFICATION_QUERIES