Oracle PL/SQL – Display source code for a Trigger

by

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
Image

mkyong

Founder of Mkyong.com, passionate Java and open-source technologies. If you enjoy my tutorials, consider making a donation to these charities.

1 Comment
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
Piotr
6 years ago

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

0
Reply