I've made a trigger like this:
TRIGGER txperson_ucase
before insert or update on txperson
begin
insert into txperson
values (PERSONID,
LASTNAME,
FIRSTNAME,
upper(USERID),
upper(PASSWORD),
ADDRESSID,
STARTdate,
ENDdate,
AVAILABILITY,
REGISTRATIONPHASE,
CREATION,
CREATORID,
MODIFICATIONID,
MODIFICATORID);
commit;
end;

where fields userid and passwod are to be put in uppercase.
Is this the right way (how does oracle know which values to take?),

Thx,


Rik