Отключение:
FOR i IN (SELECT trigger_name
FROM user_triggers
WHERE trigger_name like '%TTT%')
LOOP
EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE';
END LOOP;
Включение:
FOR i IN (SELECT trigger_name
FROM user_triggers
WHERE trigger_name like '%TTT%')
LOOP
EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' ENABLE';
END LOOP;
Комментариев нет:
Отправить комментарий