Author : Ankur narendrabhai shah
Keyword : Procedure, security, trigger
Subject : Science and technology
Article Type : Original article (research)
Article File : Full Text PDF
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.
Article by : Ankur N Shah
Article add date : 2020-12-01
How to cite : Ankur narendrabhai shah. (2020-December-01). Triggering security features of oracle. retrieved from https://www.openacessjournal.primarydomain.in/abstract/391