How many types of triggers exist in PL/SQL?

DWQA QuestionsCategory: Pl/SQLHow many types of triggers exist in PL/SQL?
Editor Staff asked 10 months ago

How many types of triggers exist in PL/SQL?

1 Answers
Editor Staff answered 10 months ago

There are 12 types of triggers in PL/SQL that contains the combination of BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL keywords.

  • BEFORE ALL ROW INSERT
  • AFTER ALL ROW INSERT
  • BEFORE INSERT
  • AFTER INSERT etc.