oracle by 1 comment

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

One comment on “Oracle PL/SQL – Display source code for a Trigger”

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

    Reply

Leave a Comment

Your email address will not be published. Required fields are marked *