查看Oracle 触发器

SELECT distinct name FROM DBA_SOURCE  WHERE  TYPE='TRIGGER' AND OWNER = 'xxxx';

 1. 查看是否正常

 

SELECT * FROM user_objects WHERE object_name in 
(SELECT distinct name FROM DBA_SOURCE  WHERE  TYPE='TRIGGER' AND OWNER = 'xxx')