Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
DBA_CQ_NOTIFICATION_QUERIES
describes the registered queries for all CQ notifications in the database.
USER_CQ_NOTIFICATION_QUERIES
describes the registered queries for the CQ notifications owned by the current user. This view does not display the USERNAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
QUERYID |
NUMBER |
ID of the query | |
QUERYTEXT |
CLOB |
Text of the query | |
REGID |
NUMBER |
Registration ID that the query is registered with | |
USERNAME |
VARCHAR2(31) |
Name of the user who registered the query |
See Also:
"USER_CQ_NOTIFICATION_QUERIES"