Mega Code Archive
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>