Row Level Vs Statement Level Triggers
ROW LEVEL TRIGGERS FIRED EACH TIME TABLE IS AFFECTED BY THE TRIGGERING STATEMENT.
STATEMENT LEVEL TRIGGERS FIRED ONCE PER TRIGGERING STATEMENT, REGARD'S OF NUMBER
OF ROWS AFFECTED BY TRIGGERING STATEMENT...
CAN GET :NEW AND :OLD COLUMN VALUES IN ROW LEVEL TRIGGERS,
BUT NOT IN STATEMENT LEVEL TRIGGERS.
ORDER OF TRIGGERS WILL BE FIRED
ROW TRIGGERS, STATEMENT TRIGGERS, AFTER ROW TRIGGERS AND STATEMENT TRIGGERS
IF WE WRITE AN SEPARATE TRIGGERS ON EACH COLUMNS, IT WILL BE GET FIRED IN
REVERSE ORDER.
I.E LAST COLUMN TRIGGERS WILL BE FIRED FIRST AND SO ON...
|
No responses found. Be the first to respond and make money from revenue sharing program.
|