| 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"