Friday, 29 Mar, 2024

+91-9899775880

011-47044510

011-49075396

Triggering Security Features of Oracle

Rungta International Journal of Computer Science and Information Technology

Volume 3 Issue 1&2

Published: 2018
Author(s) Name: Ankur N. Shah | Author(s) Affiliation: Assistant Professor, CE Department, Babaria Institute of Technology, Vadodara, Gujarat, India.
Locked Subscribed Available for All

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.

Keywords: Procedure, Security, Trigger.

View PDF

Refund policy | Privacy policy | Copyright Information | Contact Us | Feedback © Publishingindia.com, All rights reserved