王绍桦的博客CREATE OR REPLACE TRIGGER TGR_NAME ...AFTER INSERT OR UPDATE ON TABLE1_NAME FOR EACH ROW BEGIN IF inserting then INSERT INTO TABLE2_NAME (zj,mc) VALUES(:new.zj,:new.mc); ELSIF updating then UPDATE
黄宝康的博客oracle查询表是否有触发器 select trigger_name from all_triggers where table_name='PM_PA_PAYAPPLY'; 通过触发器名,获取触发器的具体内容 select text from all_source where type='TRIGGER' AND name='...