DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_CQ_NOTIFICATION_QUERIES

Object Details
Object Name: CDB_CQ_NOTIFICATION_QUERIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of registered queries for CQ notification in all containers

[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
USERNAME VARCHAR2 (31)
Name of user who registered the query
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUERYID
,      QUERYTEXT
,      REGID
,      USERNAME
,      CON_ID
FROM SYS.CDB_CQ_NOTIFICATION_QUERIES;

Dependencies

[top of page]

SYS.CDB_CQ_NOTIFICATION_QUERIES does not reference any database object

SYS.CDB_CQ_NOTIFICATION_QUERIES is referenced by following:

SchemaPUBLIC
SynonymCDB_CQ_NOTIFICATION_QUERIES