Oracle PL/SQL Tutorial/Trigger/Drop Trigger
Версия от 13:45, 26 мая 2010; (обсуждение)
Dropping a Trigger
SQL>
SQL> DROP TRIGGER yourTriggerName;
SQL>
If trigger exists, drop trigger
SQL>
SQL> BEGIN
2 FOR i IN (SELECT null FROM user_triggers WHERE trigger_name = "INSERTemp") LOOP
3 EXECUTE IMMEDIATE "DROP TRIGGER InsertBooksemp";
4 END LOOP;
5 END;
6 /
PL/SQL procedure successfully completed.
SQL>