Oracle inserts or updates a specified column to execute a trigger

Table structure:

CREATE TABLE Tz_gxsx (  ID              VARCHAR2 (),  PROJECT         VARCHAR2 (0),  txyx number            (  CDATE           DATE,  RISK            VARCHAR2 (Ten),  degree          VARCHAR2 (Ten),  PROB            VARCHAR2 (+),  pressure_ Level  VARCHAR2,  networkdivision VARCHAR2 (),  AUTHOR          VARCHAR2,  inp_date        DATE)

Direct update:

Create or replace trigger GXSX_TRG  before update on TZ_GXSX for each  rowbegin:new. Inp_date:=sysdate; EXCEPTION when OTHERS and then    RAISE; END GXSX_TRG;

Exclude the specified column name "CDATE" to perform the update:

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 and then    RAISE; END GXSX_TRG;

Oracle inserts or updates a specified column to execute a trigger