Change letter case in a trigger : Before Insert Trigger « Trigger « Oracle PL / SQL

1. Oracle PL / SQL
2. Trigger
3. Before Insert Trigger

Change letter case in a trigger

  
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> 

   
  

Related examples in the same category