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 do I count duplicates in sql?
What is sql table?
What is sql and how does it work?
Does sap use sql?
What packages(if any) has oracle provided for use by developers?
in a package one procedure is wrong package shows valid or not
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
write an sql query to find names of employee start with 'a'? : Sql dba
difference between table level constraint and column level and advantages of table level constraint
counting the no.of characters occurs in a string by using pl/sql function
Why does %isopen return false for an implicit cursor?
how to debugg a procedure or package using dbms_output.put_line in plsql