摘要:
CREATE OR REPLACE TRIGGER tri_bonusafter insertON client_infoFOR EACH ROWBEGINupdate manger_sal set bonus=bonus+100 where mid=:new.mid;END tri_bonus; 阅读全文
摘要:
CREATE OR REPLACE TRIGGER tri_loan_into_interestAFTER INSERT OR UPDATE ON loan_infoFOR EACH ROWBEGINIF INSERTING THENINSERT INTO interest_info (lid,ci 阅读全文