--行级触发器 create or replace trigger insert_person after insert on person for each row begin insert into person2 values(:new.id,:new.name,:new.password); end; create or replace trigger update_person after update on person for each row begin update pers
--创建触发器 create or replace trigger trigger_customerLink before insert on customerLink_table for each row when (new.id is null) begin select seq_link_id.nextval into:new.id from dual; end; --测试插入 insert into customerLink_table(customer_id,Link_Name,Se
Oracle触发器,用于选单后修改选单的表的触发动作。
--备货检验选单后 回写备货状态
CREATE OR REPLACE TRIGGER tri_TobaccoStockINSERT
after INSERT
ON "TobaccoStockQuality"
FOR each ROW
BEGIN
UPDATE "GoodsStock" SET "FirstCheckState"=-1 WHERE "ID"=:NEW."GoodsStock_ID";
END;
--备货检验修改选单后 回写备
下面是一个触发器的例子: 代码如下:create or replace trigger logon_ip_controlafter logon on databasedeclare ip STRING(30); user STRING(30);beginSELECT SYS_CONTEXT(‘USERENV’,’SESSION_USER’) into user from dual;SELECT SYS_CONTEXT(‘USERENV’,’IP_ADDRESS’) into ip from
本文实例讲述了mysql触发器之创建使用触发器。分享给大家供大家参考,具体如下:
我们可以可以使用CREATE TRIGGER语句创建一个新的触发器,来看下具体的语法:
CREATE TRIGGER trigger_name trigger_time trigger_event
ON table_name
FOR EACH ROW
BEGIN
...
END;
然后我们来详细看下上述sql的具体含义:
将触发器名称放在CREATE TRIGGER语句之后。触发器名称应遵循命名约