摘要: CREATE OR REPLACE TRIGGER tri_bonusafter insertON client_infoFOR EACH ROWBEGINupdate manger_sal set bonus=bonus+100 where mid=:new.mid;END tri_bonus; 阅读全文
posted @ 2019-06-09 21:15 跶哒达 阅读(200) 评论(0) 推荐(0) 编辑
摘要: CREATE OR REPLACE TRIGGER tri_loan_into_interestAFTER INSERT OR UPDATE ON loan_infoFOR EACH ROWBEGINIF INSERTING THENINSERT INTO interest_info (lid,ci 阅读全文
posted @ 2019-06-09 21:13 跶哒达 阅读(5240) 评论(0) 推荐(0) 编辑