DBA_CQ_NOTIFICATION_QUERIES describes the registered queries for all CQ notifications in the database.

Related View

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