Start Sql updating table from another table

Sql updating table from another table

Include a counter variable in your package to detect this situation.

The rollback to savepoint does not undo changes to any package variables referenced in the trigger.

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.

This type of trigger also provides an additional correlation name for accessing the parent row that contains the nested table being modified. SQL (the first part) declares variables and subprograms that timing-point sections can use.

When the trigger fires, the declarative part executes before any timing-point sections execute.

In all cases, the SQL statements running within triggers follow the common rules used for standalone SQL statements.

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.

For example, a table and a trigger can have the same name (however, to avoid confusion, this is not recommended). If a triggering statement includes a column list, the trigger fires only when one of the specified columns is updated.