Arbe,

The trigger is very simple.

create trigger txperson_ucase before insert or update on txperson for each row

begin
:new.USERID := upper(:new.USERID);
:new.PASSWORD := upper(:new.PASSWORD;
end;
/