不用告诉你在哪里去找,你把oracle自带的那几个东东都玩一遍就知道了。

解决方案 »

  1.   

    SQL> DESC user_triggers;
     名称                                      空?      类型
     ----------------------------------------- -------- --------------------
     TRIGGER_NAME                                       VARCHAR2(30)
     TRIGGER_TYPE                                       VARCHAR2(16)
     TRIGGERING_EVENT                                   VARCHAR2(216)
     TABLE_OWNER                                        VARCHAR2(30)
     BASE_OBJECT_TYPE                                   VARCHAR2(16)
     TABLE_NAME                                         VARCHAR2(30)
     COLUMN_NAME                                        VARCHAR2(4000)
     REFERENCING_NAMES                                  VARCHAR2(128)
     WHEN_CLAUSE                                        VARCHAR2(4000)
     STATUS                                             VARCHAR2(8)
     DESCRIPTION                                        VARCHAR2(4000)
     ACTION_TYPE                                        VARCHAR2(11)
     TRIGGER_BODY                                       LONG其他还有user_objects, user_views等
      

  2.   

    装个PL/SQL Developer吧,什么都看得到,或者Toad也一样。