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


  1. Oracle database – USER_SOURCE table

About the Author

author image
Founder of, love Java and open source stuff. Follow him on Twitter, or befriend him on Facebook or Google Plus. If you like my tutorials, consider make a donation to these charities.


Leave a Reply