adspace


What is the usage of when clause in trigger?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the advantages of sql ? : Sql dba

1154


What is the current version of sql?

1106


what is dbms? : Sql dba

1070


Is primary key clustered index?

1028


Do we need to rebuild index after truncate?

1154


How do I remove duplicates in two columns?

1202


If a cursor is open, how can we find in a pl/sql block?

1252


what are all the common sql function? : Sql dba

1141


Is primary key always clustered index?

1101


What is the current version of postgresql?

1188


Can delete statement be rollbacked?

1065


Is inner join faster than left join?

1287


what is schema? : Sql dba

1163


What is the best sql course?

1064


What is your daily office routine?

2353