[Home] [Help] [Dependency Information]
Object Name: | DBA_CQ_NOTIFICATION_QUERIES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of registered queries for CQ notification
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 |
Cut, paste (and edit) the following text to query this object:
SELECT QUERYID
, QUERYTEXT
, REGID
, USERNAME
FROM SYS.DBA_CQ_NOTIFICATION_QUERIES;
|
|
|