21. Creating Disabled Triggers (Code Samples).html

<pre class="prettyprint linenums">---------------------------------------------------------------------------------------------
-----------------------------------CREATING DISABLED TRIGGERS--------------------------------
---------------------------------------------------------------------------------------------  
create or replace trigger prevent_high_salary
before insert or update of salary on employees_copy 
for each row
disable
when (new.salary &gt; 50000)
begin
  raise_application_error(-20006,'A salary cannot be higher than 50000!.');
end;</pre>