Mega Code Archive
Change letter case in a trigger
<![CDATA[
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> drop table all_upper_data;
Table dropped.
SQL>
]]>