Oracle Enable all Trigger

Sometimes you might found that you have disabled all trigger on a table and you wish to enable the triggers back again. In Oracle you can enable all the triggers on a table using ALTER TRIGGER statement.

Oracle Enable all Trigger Syntax

Syntax

ALTER TABLE table_name ENABLE ALL TRIGGERS; 
</>
</div>
</div>
</div>

<div style="padding-top:10px;"></div>
<p><strong>Where:</strong></p>
<p><i>table_name</i>: The table name that all triggers should be disabled on.</p>

<div style="padding-top:10px;"></div>
<div class="panel panel-default">
<div class="well">
<div style="overflow: hidden;">
<h3>Oracle Enable all Trigger Example	</h3>
<p>To show how to Enable all the trigger using the ENABLE ALL TRIGGERS statement, use the following syntax:</p>

<div style="padding-top:10px;"></div>
<textarea class="setBorder codemirror-textarea">
ALTER TABLE tblCustomerLoan ENABLE ALL TRIGGERS;

« Previous