SQL>
SQL> Disable and enable a trigger
SQL>
SQL>
SQL> create table all_upper_data(
2 data varchar2(255) );
Table created.
SQL>
SQL> create or replace trigger bifer_all_upper_data
2 before insert
3 on all_upper_data
4 for each row
5 begin
6 :new.data := upper( :new.data );
7 end;
8 /
Trigger created.
SQL>
SQL> insert into all_upper_data( data ) values ( 'chris' );
1 row created.
SQL>
SQL> select * from all_upper_data;
DATA
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------
CHRIS
SQL>
SQL> alter trigger bifer_all_upper_data disable;
Trigger altered.
SQL>
SQL> insert into all_upper_data( data ) values ( 'sean' );
1 row created.
SQL>
SQL> select * from all_upper_data;
DATA
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------
CHRIS
sean
SQL>
SQL> alter trigger bifer_all_upper_data enable;
Trigger altered.
SQL>
SQL> insert into all_upper_data( data ) values ( 'mark' );
1 row created.
SQL>
SQL> select * from all_upper_data;
DATA
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------
CHRIS
sean
MARK
SQL>
SQL>
SQL> drop table all_upper_data;
Table dropped.
SQL>
|