Hi,
I've 2 tables (A, B)

A has this columns
cod varchar2(32) primary key
admin varchar2(32)

B has
cod varchar2(32)
cod_admin varchar2(32)

I'd to create a trigger that when I update A.admin with value 'X', in tab B I get B.cod=A.cod and B.cod_admin='999'.
This also for insert and delete.

Thanks
Raf