全部博文
-
编辑 删除
Oracle触发器的一个简单例子
用户状态酿成离职状态，系统>配置表被触收，修改配置表状态 create or replace trigger BASEDB_USERLEFT before update or delete on basedb_users for each row declare -- local variables here varcount number; begin --select loginid into userloginid from basedb_users where status=:new.status; if updating or deleting then select count(*) into varcount from basedb_sysconfuser where loginid=:new.lo
