可以实现,不过最好用两个触发器。
CREATE OR REPLACE TRIGGER BMS_GOODS_UPDATE
BEFORE UPDATE OF title
ON BMS_GOODS
FOR EACH ROW 和
CREATE OR REPLACE TRIGGER BMS_GOODS_UPDATE
BEFORE UPDATE OF name
ON BMS_GOODS
FOR EACH ROW
CREATE OR REPLACE TRIGGER BMS_GOODS_UPDATE
BEFORE UPDATE OF title
ON BMS_GOODS
FOR EACH ROW 和
CREATE OR REPLACE TRIGGER BMS_GOODS_UPDATE
BEFORE UPDATE OF name
ON BMS_GOODS
FOR EACH ROW
CREATE OR REPLACE TRIGGER BMS_GOODS_UPDATE
BEFORE UPDATE ON BMS_GOODS 然后在触发器再判断什么列处理。
现在要求表BMS_GOODS的title列更改时触发该触发器,将原来的值插入到某个表中,当name列更改的时候触发该触发器,将原来的name值插入到某个表中你两次修改所插入的表是同一表吗?
例:(当修改title时):
create or replace trigger BMS_GOODS_UPDATE_TITLE
after update on BMS_GOODS
for each row
begin
//执行sql语句,将你取的值插入到表中.
end ;