Oracle - Trigger
标签：rup display 情况下 rac none cli 技术 update after
Oracle - Trigger
OR REPLACE TRIGGER TabelNameTrigger
before INSERT OR UPDATE ON TableName
FOR EACH ROW
DECLARE
--参数
BEGIN
--业务逻辑
if :new.texture = ‘铜丝‘ then
:new.texture := ‘Cu‘;
end if;
if :new.texture = ‘金丝‘ then
:new.texture := ‘Au‘;
end if;
END;
View Code