if u enter emp_name in emp table in ename field's in any case it will be inserted in capital letters's only

 Create or replace trigger cap before insert on emp 

for each row 

begin 

:New.ename = upper(:New.ename); 

end;