| 发表于:2007-04-13 16:02:50 楼主 |
create trigger new_hired after insert on osys_program referencing new as newquote for each row mode db2sql delete from osys_program_listeningtable_t where prog_no=newquote.prog_no insert into osys_program_listeningtable_t(prog_no,prog_name,prog_desc) values(newquote.prog_no,prog_name,prog_desc); |
|
|
|
|