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 |
what is 'mysqlcheck'? : Sql dba
Is crud a cuss word?
What is normalisation in sql?
What is an oracle stored procedure?
What is the difference between count 1 and count (*) in a sql query?
What is union, minus and interact commands?
What is a primary key sql?
How can use stored procedures in sql?
Does pl sql work in mysql?
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);
Can we perform dml in function?
What are system versioned tables?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)