1. – Assistant Professor, Ce Department, Babaria Institute Of Technology, Vadodara, Gujarat, India.
| Received
27-Nov-2018 |
Accepted
- |
Published
27-Nov-2018 |
Abstract
Database trigger is a PL/SQL block that is executed on an event in the database. The event is related to a particular data manipulation of a table such as inserting, deleting or updating a row of a table [8]. Triggers are automatically fired when condition written for trigger is matched. Thus it provides security to database by avoiding harmful operations on database. The triggers are also cascading, so trigger can be called by another trigger. There are also various types of triggers available. Even there are various advantages of using trigger, the excessive use of triggers can result in complex interdependences, which may be difficult to maintain in a large application. So it advisable to used trigger when they are really needed.
Locked
Subscribed
Open Access
Open Access