##### 트리거 UPDATE #####
CREATE OR REPLACE TRIGGER ATRI_TBL_MEMBER_UPDATE -- 에프터 트리거
AFTER UPDATE OF PASSWD -- 패스워드 컬럼에만
ON TBL_MEMBER
FOR EACH ROW
BEGIN
UPDATE TBL_LOGIN
SET PASSWD = :NEW.PASSWD
WHERE ID = :NEW.ID
END;
UPDATE TBL_MEMBER
SET PASSWD ='ORACLE302'
WHERE ID ='HONGKD';
##### 트리거 DELETE #####
CREATE OR REPLACE TRIGGER ATRI_TBL_MEMBER_DELETE
AFTER DELETE
ON TBL_MEMBER
FOR EACH ROW
BEGIN
DELETE TBL_LOGIN
WHERE ID = :OLD.ID;
END;
DELETE TBL_MEMBER
WHERE ID ='HONGKD';
