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