Oracle 触发器两种写法

//复杂触发器，功能 数据插入是触发数据联动
//注意 :new.DATA_REGION := 才是赋值
CREATE
OR REPLACE TRIGGER TRIGGER_NAME 
BEFORE INSERT ON TABLE_NAME 

FOR EACH ROW
DECLARE 
CREATE_USER_ID VARCHAR (40) ;
CREATE_DATE DATE ; 
DH_EVENT_ID VARCHAR (50) ; 
DATA_REGION VARCHAR (10) ; 

BEGIN
SELECT
    USER_NAME  INTO   CREATE_USER_ID
  FROM    link_name
    where TRUE_NAME =:NEW.CREATER;
  
	:new.CREATE_DATE := SYSDATE ; 
   :new.DH_EVENT_ID := RAWTOHEX (SYS_GUID()) ; 
   :new.DATA_REGION := 'HH' ; 
   :new.CREATE_USER_ID := CREATE_USER_ID ; 
	END ;

//简单触发器 插入数据触发
CREATE OR replace trigger TRIGGER_NAME
before insert on TABLE_NAME
for each row 
begin
:new.INPUT_DATE :=TO_CHAR (
    sysdate,
    'yyyy-MM-dd hh24:mi:ss'
  ) ;
:new.DH_EVENT_ID:=rawtohex(sys_guid());
end;