FIND ALREADY INSTALLED TRIGGER TEXT in a database

select * from ALL_SOURCE where TYPE='PACKAGE';

select * from all_objects where object_TYPE='PROCEDUE';
select * from all_objects where object_TYPE='FUNCTION';
select * from all_objects where object_TYPE='TRIGGER';