VIEW: SYS.DBA_CQ_NOTIFICATION_QUERIES

Source

View Text - Preformatted

select q.queryid, querytext, r.regid, username     from sys.x$ktcnquery q, sys.x$ktcnregquery r, sys.x$ktcnreg reg where q.queryid =  r.queryid and r.regid = reg.regid

View Text - HTML Formatted

SELECT Q.QUERYID
, QUERYTEXT
, R.REGID
, USERNAME
FROM SYS.X$KTCNQUERY Q
, SYS.X$KTCNREGQUERY R
, SYS.X$KTCNREG REG
WHERE Q.QUERYID = R.QUERYID
AND R.REGID = REG.REGID