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.

Leave a Reply