Diff. types of triggers..

Answer Posted / pratap

There are mainily 3 types of triggers
1> DML Trigger
2> Instead of Trigger written on only view
3> System Trigger

DML Trigger written on table that gets fired on DML events
like
insert or delete or update operation
that trigger may fire
1> After dml event
2> Before dml event these are timings for trigger firing

Instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

System trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
Database level
Schema level

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is best database for java?

527


Differentiate between type_scroll_insensitive and type_scroll_sensitive.

524


What driver should I use for scalable Oracle JDBC applications?

507


Is it possible to connect to multiple databases simultaneously?

555


What is jdbc in java?

493






Explain about the drive manager class working?

608


How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?

583


What is jdbc and explain jdbc architecture?

520


What is the difference between jdbc and jndi?

497


Where can I find ojdbc14 jar file?

496


If I use the JDBC API, do I have to use ODBC underneath?

606


What is jdbc driver manager?

499


How are jdbc statements used?

506


Is jdbc secure?

514


Which is better jpa or jdbc?

507