create or replace trigger trg_c_a after insert on a referencing new as new old as old for each rowbegin insert into c select :new.id,b.id ,:new.name1,:new.password1 from b where b.describe=:new.describe;end;