trigger before insert or update
Using Oracle 11g I have a trigger that is before insert or update. Rather than code two triggers is there a system variable, like trigger fire type, to test whether the trigger is firing because of an insert or update. Currently I test the old id column for being null, but assume there is another more appropriate way?
IF :OLD.column_id IS NOT NULL THEN
*** perform logic for insert
0