what is trigger?

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


Please Help Members By Posting Answers For Below Questions

Difference between varchar and varchar2 data types?

666


What are ddl statements in oracle?

592


What is raw datatype?

593


What is the difference between $oracle_base and $oracle_home?

585


How many categories of data types?

574






How data locks are respected in oracle?

574


what is meant by magic query

1773


How many types of database triggers exist?

575


What is a server parameter file in oracle?

594


How do I learn what codesets are available in oracle?

575


What is control file used for?

602


How many file formats are supported to export data?

659


What is a snapshot in oracle database?

578


What is the maximum number of triggers that can be applied to a single table?

558


what is the difference between restoring and recovering?

558