Oracle PL/SQL – Display source code for a Trigger

The following SQL shows you how to get the source code for a specified trigger :

select text from user_source where name ='&trigger_name' and type ='TRIGGER';

References

1. Oracle database – USER_SOURCE table