oracle插入或更新某一个指定列来执行触发器

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

表结构：

create table TZ_GXSX
(
ID VARCHAR2(15),
PROJECT VARCHAR2(50),
TXYX NUMBER(22) default '0',
CDATE DATE,
RISK VARCHAR2(10),
DEGREE VARCHAR2(10),
PROB VARCHAR2(10),
PRESSURE_LEVEL VARCHAR2(20),
NETWORKDIVISION VARCHAR2(20),
AUTHOR VARCHAR2(20),
INP_DATE DATE
)

直接更新：

create or replace trigger GXSX_trg
before update ON TZ_GXSX
FOR EACH ROWBEGIN
:new.INP_DATE:=sysdate;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END GXSX_trg;

排除指定列名"CDATE" 来执行更新:

create or replace trigger GXSX_trg
before update ON TZ_GXSX
FOR EACH ROWBEGIN
if updating('CDATE')=false
then
:new.INP_DATE:=sysdate;
end if;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END GXSX_trg;