What is the usage of when clause in trigger?



What is the usage of when clause in trigger?..

Answer / Prem Prakash Verma

"The WHEN clause in a trigger allows you to specify conditions that determine when the trigger should be fired. When a row is inserted, updated, or deleted, PL/SQL evaluates these conditions and executes the corresponding action if they are met."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is sql server agent? : Sql dba

0 Answers  


What does where 1/2 mean in sql?

1 Answers  


Can we call a function containing dml statements in a select query?

1 Answers  


What is a schema in sql?

1 Answers  


What are the different set operators available in sql?

1 Answers  


what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,


what are null values? : Sql dba

1 Answers  


What is write ahead logging in sql server?

1 Answers  


What is the best partition size for windows 10?

1 Answers  


How do we accept inputs from user during runtime?

1 Answers  


Is nosql relational?

1 Answers  


what are different types of keys in sql?

1 Answers  


Categories