23.05.10 데이터베이스

트리거

작성법

CREATE TRIGGER trigger_name 
timing[BEFORE|AFTER] event[INSERT|UPDATE|DELETE]
ON table_name
[FOR EACH ROW]
[WHEN conditions]

BEGIN 
statement
END

INSERT INTO abctest@db_link(aaa, aaa2, aaa3)
VALUES ( ( SELECT aaa FROM aaa WHERE aaa = '199909054') , 'aaa2','aaa3');