PL/SQL Triggers

How many types of PL/SQL Triggers are there? What are they?

Showing Answers 1 - 3 of 3 Answers

sravanthi

  • Aug 13th, 2015
 

There are two different types of triggers:
- Application Triggers
- Database Triggers

An application trigger fires whenever an event occurs within a particular application.

A database trigger fires whenever a data event such as a DML event, or a system event such as a logon or shutdown occurs on a schema or database.

  Was this answer useful?  Yes

Yogesh

  • Jun 2nd, 2017
 

Basically the are 5 type of trigger on basis of triggering events
1. DML
2. DDL
3. System or schema level
4. Compound
5. Instead of

  Was this answer useful?  Yes

Chandra sekhar

  • Jun 23rd, 2017
 

Two types
ROW LEVEL
STATEMENT LEVEL

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions