what is trigger?

Answer Posted / abhisek pattnaik

Trigger is a type of programme which is automatically
executed when ever a DML operation is made on a perticular
table.
Trigger is identical with procedure but the basic
difference between them is procedure is explicitly created
& executed by the user where as trigger is explicitly
created but implicitly fired or executed when ever a DML
operation is made.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the different type of segments?

578


what is IDE,DMV in sql server?

2248


What is the difference between translate and replace?

560


How to divide query output into groups in oracle?

563


Where do we use decode and case statements?

563






how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4668


What is the difference between a user and a schema in oracle?

562


What is oracle join syntax?

570


State and explain about oracle instance?

551


What is the difference between alert log file and tarce file ?

1634


Can select statements be used on views in oracle?

594


Explain the importance of .pll extension in oracle?

555


What is meant by an index?

619


What is the difference between sharding and replication?

479


What is difference between truncate and delete?

561