title: Oracle/SQL: Check If Trigger Enabled/Disabled
body: <p>How do you check if a specific trigger is enabled or disabled in Oracle/SQL?</p>
  
  <p>The following specifies if my trigger is valid or not -- but not enabled or disabled</p>
  
  <pre><code>SELECT *
  FROM   ALL_OBJECTS
  WHERE  OBJECT_TYPE = 'TRIGGER' AND OBJECT_NAME = 'the_trigger_name';
  </code></pre>
  
  <p>My Oracle Database version: 12c - Enterprise Edition v12.1.0.2.0 - 64bit</p>
  
  <hr>
  
  <p>I have checked StackOverflow and came across the following posts, but didn't find an answer specific to Oracle/SQL:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/8136937/sql-server-check-whether-a-trigger-is-enabled-or-disabled">SQL Server: check whether a Trigger is Enabled or Disabled?</a></li>
  <li><a href="https://stackoverflow.com/questions/34246317/oracle-sql-status-check-trigger">ORACLE SQL Status check trigger</a></li>
  <li><a href="https://stackoverflow.com/questions/120900/how-to-check-if-a-trigger-is-invalid">How to check if a trigger is invalid?</a></li>
  </ul>