Trigger inserting updating deleting
By default, a trigger is created in the enabled state. When a trigger fires, tables that the trigger references might be undergoing changes made by SQL statements in other users' transactions.SQL statements running in triggers follow the same rules that standalone SQL statements do. This statement can be used with any interactive tool, such as SQL*Plus or Enterprise Manager.When using an interactive tool, a single slash (/) on the last line is necessary to activate the 0) DECLARE sal_diff number; BEGIN sal_diff := :- :old.sal; dbms_output.put('Old salary: ' ' When Inserting'); ELSIF UPDATING THEN dbms_output.put_line(v Msg
In particular, if an uncommitted transaction has modified values that a trigger being fired either must read (query) or write (update), then the SQL statements in the body of the trigger being fired use the following guidelines: privilege.