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

Difference between cartesian join and cross join?

540


How to store only time; not date and time?

555


What are the logical operations?

673


How to fetch the row which has the max value for a column?

538


What is oracle database 10g express edition?

593






Can we use bind variables in oracle stored procedure?

484


What is the implicit cursor in oracle?

562


How do I use os authentication with weblogic jdriver for oracle and connection pools?

568


Can objects of the same schema reside in different tablespace?

583


What happens to the current transaction if a ddl statement is executed?

572


What is the usage of synonyms?

580


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1736


WHAT IS ecc 6.0

1653


Explain a segment?

610


How to end the current transaction in oracle?

546