|
최길호
[LIST]
|
2019-03-30 22:18:33, 조회 : 667 |
-- db2 9.7
create table trg_test ( id number,val number )
create table trg_log ( dt varchar2(10),dml varchar2(2),cnt number)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE,'YYYYMMDD'),'I',0)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE,'YYYYMMDD'),'D',0)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE,'YYYYMMDD'),'U',0)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE+1,'YYYYMMDD'),'I',0)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE+1,'YYYYMMDD'),'D',0)
INSERT INTO TRG_LOG VALUES (TO_CHAR(SYSDATE+1,'YYYYMMDD'),'U',0)
-- auto commit
CREATE OR REPLACE trigger trg_i
AFTER INSERT ON TRG_TEST FOR EACH ROW
UPDATE TRG_LOG SET CNT= CNT + 1 WHERE DT = TO_CHAR(SYSDATE,'YYYYMMDD') AND DML = 'I'
CREATE OR REPLACE trigger trg_u
AFTER UPDATE ON TRG_TEST FOR EACH ROW
UPDATE TRG_LOG SET CNT= CNT + 1 WHERE DT = TO_CHAR(SYSDATE,'YYYYMMDD') AND DML = 'U'
CREATE OR REPLACE trigger trg_d
AFTER DELETE ON TRG_TEST FOR EACH ROW
UPDATE TRG_LOG SET CNT= CNT + 1 WHERE DT = TO_CHAR(SYSDATE,'YYYYMMDD') AND DML = 'D'
insert into trg_test values ( 1,1001)
update trg_test set val = 1002
delete trg_test where id=1
select * from trg_test
select * from trg_log
update trg_log set cnt=0
|
3.238.125.76
|
|
06/29 