• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
E-gineering

E-gineering

  • Who We Are
    • Our Story
    • Leadership Team
    • Whole Team
  • What We Do
    • Practices
    • Full Services
    • Success Stories
  • Working Here
    • Careers
    • Work Life
    • Community Life
    • Fun Life
  • Blog
  • Contact Us

Getting the Status of an Oracle Trigger

May 24, 2012 by Christian Desserich

Oracle Trigger-01Just a quick post about trying to determine the enabled/disabled status of an Oracle trigger. I found code snippets like this:

select status from user_triggers
where trigger_name = 'XXX';

Or like this:

select * from all_objects
where object_type = 'TRIGGER' and object_name='XXX';

The first only gives you the triggers owned by the user session so if you are logged in as the admin, this won’t work for a trigger in a schema. The second one doesn’t work because the status of the object as Valid/Invalid. I figured if there is an all_objects table, there must be an all_triggers table. There is. This worked for me:

select status from all_triggers
where owner = '<SCHEMA NAME>'
and trigger_name = '<TRIGGER NAME>';
Category: DataTag: Oracle, SQL

About Christian Desserich

Previous Post:E-gineering Golf Outing 2011
Next Post:Toy-gineering – Christmas 2013

Let’s work together

Get in touch with us and send some basic info about your project.

Get in touch!

Social

Follow along on social media

  • Mail
  • Facebook
  • GitHub
  • Instagram
  • LinkedIn
  • Twitter

Navigation

Home

Who We Are

What We Do

Working Here

Blog

Contact Us

Contact

8415 Allison Pointe Blvd
Suite 200
Indianapolis, IN 46250

317.348.1780

info@e-gineering.com

© Copyright 2023 | E-gineering, Inc.

Return to top