CREATE TABLE AAA ( FIELD_A VARCHAR2(50) );
CREATE TABLE BBB ( FIELD_B VARCHAR2(50) );
CREATE OR REPLACE TRIGGER TRG_CHAGE_TEST
INSTEAD OF INSERT OR UPDATE OR DELETE ON AAA
FOR EACH ROW
DECLARE
NEW_VAL VARCHAR2(59);
BEGIN
IF INSERTING THEN
INSERT INTO BBB VALUES ( :NEW.FILED_A );
ELSIF UPDATING THEN
UPDATE BBB SET FILED_B = :NEW.FILED_A;
ELSIF DELETING THEN
DELETE FROM BBB;
END IF;
END;
--------------------------------------------//
이유를 모르겠습니다.
생성 자체가 안됩니다. ㅠㅠ