Answer Posted / dhanalakshmi parthasarathy
Triggers are simply stored procedures that are ran
automatically by the database whenever
some event (usually a table update) happens. We won’t spend
a great deal of time talking
about how to write triggers, because if you know how to
write stored procedures, you already
know how to write triggers. What we will discuss is how to
set them up to be executed whenever something happens to
the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is index-organized table in Oracle?
What is memory advisor in Oracle?
Explain drop constraint oracle?
What is the parameter mode that can be passed to a procedure?
How many types of tables supported by oracle?
How to convert dates to characters in oracle?
How to create a stored function in oracle?
What do you understand by a database object? Can you list a few of them?
How to commit the current transaction in oracle?
How to view all columns in an existing table?
How to find the duplicate rows count from employees table in oracle?
How to define a sub function?
What is flashback in Oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to create a stored program unit?