/*
@ 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;