Oracle trigger if updating then

If same had to be done without compound-trigger, it might have been required to share data using packages.

oracle trigger if updating then-12

SQL DELETE FROM compound_trigger_test; BEFORE STATEMENT - DELETE BEFORE EACH ROW - DELETE (old.id=2) AFTER EACH ROW - DELETE (old.id=2) BEFORE EACH ROW - DELETE (old.id=1) AFTER EACH ROW - DELETE (old.id=1) AFTER STATEMENT - DELETE 2 rows deleted.

END BEFORE STATEMENT; BEFORE EACH ROW IS BEGIN NULL; -- Do something here.

END BEFORE EACH ROW; AFTER EACH ROW IS BEGIN NULL; -- Do something here.

NEXTVAL; IF INSERTING THEN g_change_tab(g_change_tab.last).action := 'INSERT'; ELSE g_change_tab(g_change_tab.last).action := 'UPDATE'; END IF; g_change_tab(g_change_tab.last).tab1_id := :new.id; g_change_tab(g_change_tab.last).created_time := SYSTIMESTAMP; END AFTER EACH ROW; AFTER STATEMENT IS l_count NUMBER(10); BEGIN FOR i IN g_change_tab.first ..

g_change_LOOP SELECT COUNT(*) INTO g_change_tab(i).record_count FROM tab1; END LOOP; FORALL i IN g_change_tab.first ..

Leave a Reply