What is the difference between row level and statement level trigger?



What is the difference between row level and statement level trigger?..

Answer / Smriti Chauhan

A row-level trigger is fired once for each affected row in a data manipulation operation (INSERT, UPDATE, or DELETE). A statement-level trigger is fired once per SQL statement.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is 'mysqlcheck'? : Sql dba

1 Answers  


Is crud a cuss word?

1 Answers  


What is normalisation in sql?

1 Answers  


What is an oracle stored procedure?

1 Answers  


What is the difference between count 1 and count (*) in a sql query?

1 Answers  


What is union, minus and interact commands?

1 Answers  


What is a primary key sql?

1 Answers  


How can use stored procedures in sql?

1 Answers  


Does pl sql work in mysql?

1 Answers  


how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


Can we perform dml in function?

1 Answers  


What are system versioned tables?

1 Answers  


Categories