Oracle trigger if not updating

' When Deleting'); END IF; END statement_level; / BEGIN SELECT seq_t. To learn whether and in what ways the columns of an inherently updatable view can be modified, query the USER_UPDATABLE_COLUMNS data dictionary view.The information displayed by this view is meaningful only for inherently updatable views.

Syntax Specify the name of the trigger to be created.

Therefore, you should not write triggers intended to affect the content of the materialized view. In other words, the database fires the triggers instead of performing DML on the view.

Like a stored procedure, a trigger is a named PL/SQL unit that is stored in the database and can be invoked repeatedly.

Constraint behavior depends on constraint state, as explained in .

Constraints are easier to write and less error-prone than triggers that enforce the same rules.


Leave a Reply

  1. Cam4 live chat ultimate 30-Mar-2017 00:29

    I’m a girl, an American-Indian girl, and therefore am not Swedish.

  2. gay speed dating oakland 15-Feb-2017 00:55

    Big tits and huge dicks - Video Chat with trannies now..