what is trigger?

Answer Posted / ashish

Triggers are stored procedures created in order to enforce
integrity rules in a database. A trigger is executed every
time when database modification done.
Triggers are executed automatically on occurance of one of
the data-modification operations.
A trigger is a database object directly associated with a
particular table. It fires whenever a specific
statement/type of statement is issued against that table.
The types of statements are insert,update,delete and query
statements.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the system predefined user roles?

585


What are the various types of snapshots ?

562


Can the query output be sorted by multiple columns in oracle?

574


Explain what are the type of synonyms?

582


What is hot backup and logical backup?

609






Explain what are the uses of rollback segment?

585


Can objects of the same schema reside in different tablespace?

590


What is the use of oracle?

556


What is the difference between translate and replace in oracle?

654


How to check the server version in oracle?

613


Explain the use of ignore option in imp command.

575


Difference between the “verify” and “feedback” command?

773


What is primefaces used for?

559


How do I use unicode codesets with the weblogic jdriver for oracle driver?

550


what is the difference between functional dependecy and multilevel dependency?

1994