What is a database trigger ? Name some usages of database
trigger ?
Answers were Sorted based on User's Feedback
Answer / swapnareddy
Database trigger is a stored procedure that invokes
automatically when a predefined event occurs.
The usage of database trigger is to audit the data modification.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / tina
Database triggers are invoked on database level (not on
table level). For e.g. you can write the triggers as and
when database is shutdown or database is getting on etc...
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sohail
Database trigger is a 4th named block in oracle.The usage
of database trigger is to audit data modification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amol maske
Database triggeris the stored procedure called when the
insert, update, delete (DML statement) fired
| Is This Answer Correct ? | 1 Yes | 0 No |
How bulk collect improves performance?
what is try_catch block in procedure
Where is all the data on the internet stored?
Why is sql*loader direct path so fast?
write a query to display diference between two dates in sql server
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
What is the maximum size of sqlite database?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
What is data type in database?
How to find only %th Highest Sal
How can you create Cursor with parametres ?
What's the difference between inner join and left join?
Oracle (3259)
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)