[Oracle] Enable / Disable all triggers in Schema

Disable Triggers

BEGIN
FOR i IN (SELECT trigger_name
FROM user_triggers) LOOP

EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE';

END LOOP;
END;
/

Enable Triggers

BEGIN
FOR i IN (SELECT trigger_name
FROM user_triggers) LOOP

EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' ENABLE';

END LOOP;
END;
/

Name (required)

Email Address (required, will not be published)

Website Address

<%= commentBody %>