title: Can an Oracle trigger be disabled for the current session?
body: <p>I'd like to disable a specific trigger on a table prior to inserting data into it, but <strong>without affecting other users</strong> that may be changing data in that same table.  I can't find any documented way to do this.  This is Oracle 11g.</p>
  
  <p>The best solution I've been able to come up with is to create a session variable and have my application set that to some value that the trigger checks for prior to doing its work.</p>
  
  <p><em>Obligatory anti-trigger comment:</em> I hate triggers.</p>