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 to get @@error and @@rowcount at the same time? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
What is duration in sql profiler trace?
How do you rename a table in sql?
How to add, remove, modify users using sql?
What are operators available in sql?
how to show all tables with 'mysql'? : Sql dba
What is trigger and stored procedure in sql?
Is nosql faster than sql?
How many unique keys can a table have?
Is big data nosql?
Can we change the table name in sql?