How many types of triggers exist in PL/SQL?

Category: Pl/SQLHow many types of triggers exist in PL/SQL?
Editor">Editor Staff asked 2 years ago

How many types of triggers exist in PL/SQL?

1 Answers
Editor">Editor Staff answered 2 years 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.