Answers

Question and Answer:

  Home  Oracle PL-SQL

⟩ How many types of database triggers can be specified on a table? What are they?

Insert Update Delete

Before Row o.k. o.k. o.k.

After Row o.k. o.k. o.k.

Before Statement o.k. o.k. o.k.

After Statement o.k. o.k. o.k.

If FOR EACH ROW clause is specified, then the trigger for each Row affected by the statement.

If WHEN clause is specified, the trigger fires according to the returned Boolean value.

 233 views

More Questions for you: