What is compound trigger?



What is compound trigger?..

Answer / Shubham Saxena

A compound trigger is a PL/SQL construct that allows a single trigger to handle multiple events (like INSERT, UPDATE, DELETE) on the same table. It consists of multiple sub-blocks (BEFORE, AFTER, and INSTEAD OF) for different types of events.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1 Answers  


What is the use of procedures?

1 Answers  


Which constraints we can use while creating database in sql?

1 Answers  


what are different types of collation sensitivity? : Sql dba

1 Answers  


What is the difference between python and sql?

1 Answers  


What is cursor explain with example?

1 Answers  


How to return an array from java to pl/sql?

1 Answers  


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1 Answers  


What are the 3 types of behavioral triggers?

1 Answers  


What are the different ways to optimize a sql query?

1 Answers  


What is a dirty read sql?

1 Answers  


Is mariadb a nosql database?

1 Answers  


Categories