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')
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')