set showmode off echo off
set heading off pagesize 0 timing off feedback off linesize 90
Rem
Rem Script Name   : dbc_drop_triggers.sql
Rem Authors Name  : Stephen Rea
Rem Purpose       : Generate and optionally run the drop triggers script
Rem                 (dbc_drop_triggers_do.sql) for the current database
Rem                 change triggers ('DBC%').
Rem
Rem Modification History:
Rem Date        Modified by     Reason
Rem 1/25/00     Stephen Rea     Fixed 'not yes' prompt test.
Rem
set termout off verify off
spool dbc_drop_triggers_do.sql
select 'drop trigger ' || owner || '.' || trigger_name || ';'
from dba_triggers where trigger_name like 'DBC%';
select 'set termout on;' from dual;
select 'select owner,trigger_name,status from dba_triggers' ||
' where trigger_name like ''DBC%'';' from dual;
spool off
!echo ""
!echo "To drop the change and insert/delete triggers:"
!echo "  @dbc_drop_triggers_do.sql"
!echo ""
set termout on
accept ans char prompt 'Run drop trigger sql above (y or n)? '
set termout off
spool dbc_drop_triggers_run.sql
select '@dbc_drop_triggers_do.sql' from dual where lower('&ans') = 'y';
select 'commit;' from dual where lower('&ans') = 'y';
select '!echo "Triggers dropped"' from dual where lower('&ans') = 'y';
select '!echo "Triggers not yet dropped"' from dual
  where lower(nvl('&ans','n')) != 'y';
spool off
@dbc_drop_triggers_run.sql
set linesize 80 termout on heading on pagesize 24 timing on feedback 6
set verify on echo on showmode both