Home » PL/SQL MCQs

What does FOR EACH ROW clause do in Trigger syntax?

103. What does FOR EACH ROW clause do in Trigger syntax?

1. A row-level trigger is specified, meaning that each row is affected by this trigger
2. When the SQL statement is run, the trigger will be executed just once, which is what is called a table-level trigger
3. Both A. and B.
4. None of the above

Answer: C) Both A. and B.

Explanation:

In the case of FOR EACH ROW –

1. A row-level trigger is specified, meaning that each row is affected by this trigger
2. When the SQL statement is run, the trigger will be executed just once, which is what is called a table-level trigger