CREATE TABLE TB_CUSTOMERS
(
  CST_ID Varchar(50) NOT NULL,
  CST_NO Integer DEFAULT 0 NOT NULL,
  CST_CMP_NO Integer DEFAULT 0 NOT NULL,
  CST_NAME Varchar(250) DEFAULT 'Абонент',
  CST_STREET Varchar(250) DEFAULT 'Улица',
  CST_HOUSE Varchar(250) DEFAULT 'Дом',
  CST_APT Varchar(10) DEFAULT 'Кв',
  CST_GROUP Integer DEFAULT 0 NOT NULL,
  CST_TYPE Integer DEFAULT 0 NOT NULL,
  CST_CLASS Integer DEFAULT 0 NOT NULL,
  CST_STATUS Integer DEFAULT 0 NOT NULL,
  CST_MEMO Blob sub_type 1,
  CST_CREATOR Varchar(50) DEFAULT 'SYS' NOT NULL,
  CST_CREATED Timestamp DEFAULT CURRENT_TIMESTAMP,
  CST_MODIFIER Varchar(50) DEFAULT 'SYS' NOT NULL,
  CST_MODIFIED Timestamp DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (CST_ID),
  UNIQUE (CST_NO,CST_CMP_NO)
);

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
 ON TB_CUSTOMERS TO  SYSDBA WITH GRANT OPTION;

SET TERM ^ ;

CREATE TRIGGER TR_TB_CUSTOMERS_AU FOR TB_CUSTOMERS
ACTIVE AFTER UPDATE POSITION 0
AS 
BEGIN 
    NEW.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

SET TERM ; ^ 

SET TERM ^ ;

CREATE TRIGGER TR_TB_CUSTOMERS_BU FOR TB_CUSTOMERS
ACTIVE AFTER UPDATE POSITION 0
AS 
BEGIN 
    OLD.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

SET TERM ; ^

SET TERM ^ ;

CREATE TRIGGER TR_TB_CUSTOMERS_AU FOR TB_CUSTOMERS
ACTIVE AFTER UPDATE POSITION 0
AS 
BEGIN 
    NEW.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

[SRC PLSQL]SET TERM ; ^ 

SET TERM ^ ;

CREATE TRIGGER TR_TB_CUSTOMERS_BU FOR TB_CUSTOMERS
ACTIVE BEFORE UPDATE POSITION 0
AS 
BEGIN 
    OLD.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

SET TERM ; ^ 

CREATE TRIGGER TR_TB_CUSTOMERS_BU FOR TB_CUSTOMERS
ACTIVE BEFORE UPDATE POSITION 0
AS 
BEGIN 
    NEW.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

SET TERM ; ^ 

CREATE TRIGGER TR_TB_CUSTOMERS_BU FOR TB_CUSTOMERS
ACTIVE BEFORE UPDATE POSITION 0
AS 
BEGIN 
    NEW.CST_MODIFIED = CURRENT_TIMESTAMP;
END^

SET TERM ; ^