Prevents avg from updating brett davern dating jillian rose reed: OLD.sal); dbms_output.put(' New salary: '
You might omit this clause if you just want to record the fact that the operation occurred, but not examine the data for each row.
Include a counter variable in your package to detect this situation.
A relational database does not guarantee the order of rows processed by a SQL statement.
A compound trigger defined on a table has one or more of the timing-point sections described in Table 9-1.
Timing-point sections must appear in the order shown in Table 9-1.