I have created this statement level trigger but it executes like row level trigger...
CREATE OR REPLACE TRIGGER trg_citizens_log
AFTER INSERT ON citizens
BEGIN
INSERT INTO trigger_log ( log_id,trigger_name, log_time)
VALUES ( trigger_log_SEQ.nextval,'STATEMENT_TRIGGER', SYSTIMESTAMP );
END;
/
I have checked with these insert script..
BEGIN
INSERT INTO CITIZENS VALUES (2, 'JOSH', 'MARK', 40);
INSERT INTO CITIZENS VALUES (3, 'MANI', 'RAJ', 38);
INSERT INTO CITIZENS VALUES (4, 'VIGNESH', 'KUMAR', 34);
END;
/
INSERT ALL
INTO CITIZENS VALUES (2, 'JOSH', 'MARK', 40)
INTO CITIZENS VALUES (3, 'MANI', 'RAJ', 38)
INTO CITIZENS VALUES (4, 'VIGNESH', 'KUMAR', 34)
SELECT * FROM dual;
Can anyone explain me why its behaving like this?