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 |
No comments:
Post a Comment