ALTER TRIGGER update_salary DISABLE;
In PL/SQL, you can disable a trigger using the following SQL command:
ALTER TRIGGER trigger_name DISABLE;
So, to disable the trigger named update_salary
, you would execute:
ALTER TRIGGER update_salary DISABLE;
This statement will prevent the trigger from firing until it is explicitly enabled again using the ENABLE
option:
ALTER TRIGGER update_salary ENABLE;
Keep in mind that you may need appropriate privileges to disable or enable triggers.