Oracle - Trigger
时间：2021-07-01 10:21:17
帮助过：19人阅读
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
Oracle - Trigger
标签：rup display 情况下 rac none cli 技术 update after
