Oracle Trigger

/*
@ Jay
@測試Trigger,如果新增數據中NAME欄位為B開頭的，則將STATUS改為Y
*/

 

CREATE OR REPLACE TRIGGER TRG_JAY_TEST
  BEFORE INSERT ON JAY_TEST_TRIGGER
  REFERENCING OLD AS OLD NEW AS NEW
  FOR EACH ROW
DECLARE
  V_ID VARCHAR2(10);
  V_NAME VARCHAR2(10);
BEGIN
   V_ID := :NEW.ID;
   V_NAME := :NEW.NAME;
 IF SUBSTR(TRIM(V_NAME),1,1) LIKE 'B%' THEN
    :NEW.STATUS := 'Y';
 END IF;
END TRG_JAY_TEST;