Re: DBA_SOURCE vs DBA_TRIGGERS

From: Michael J. Moore <hicamel_x_the_spam_at_attbi.com>
Date: Wed, 18 Sep 2002 20:41:21 GMT
Message-ID: <Rx5i9.355628$_91.455690@rwcrnsc51.ops.asp.att.net>

I am not sure what this means but ...

SQL> SELECT trigger_name
  2 FROM user_triggers
  3 INTERSECT
  4 SELECT name
  5 FROM user_source;

TRIGGER_NAME

---

AURORA$SERVER$SHUTDOWN
AURORA$SERVER$STARTUP

CDC_ALTER_CTABLE_BEFORE
CDC_CREATE_CTABLE_AFTER
CDC_CREATE_CTABLE_BEFORE
CDC_DROP_CTABLE_BEFORE
EMP_TRIGGER

NO_VM_CREATE
NO_VM_DROP
SYS_LOGOFF
SYS_LOGON 11 rows selected. Received on Wed Sep 18 2002 - 15:41:21 CDT