Main Tutorials

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 Author

author image
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

Subscribe
Notify of
1 Comment
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
Piotr
4 years ago

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