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

About the Author

author image
mkyong
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.

Comments

avatar
1 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
1 Comment authors
Piotr Recent comment authors
newest oldest most voted
Piotr
Guest
Piotr

what should stay as user_source?
DB name, Triggers, or what?