Meaning of TRIGGERS In PL/SQL

Posted Date: 11 May 2008 Resource Type: Articles/Knowledge Sharing Category: Computer & Technology

Posted By: Nikky Member Level: Gold
Rating:

Points: 2

TRIGGERS

A trigger is a stored PL/SQL code block attached and executed by an event which occurs to a database table. Triggers are implicitly invoked by DML commands. Triggers are stored as text and compiled at execute time, because of this it is wise not to include much code in them but to call out to previously stored procedures or packages as this will greatly improve performance. Triggers contain SQL or PL/SQL statements which are executed as a unit and can call other procedures and triggers. A trigger may not issue any transaction control statements like COMMIT, ROLLBACK and SAVEPOINT etc. the body of trigger cannot declare any LONG or RAW LONG variable. Triggers may be executed thousands of times for a large update. A trigger defines an action that database have to take when some database-related event (such as INSERT, UPDATE, DELETE) occurs. Triggers can have the same name as a table or procedure.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Display a message to check whether the record is deleted or not with the use of SQL%NOTFOUND
	Previous Resource: FRAMEWORK Of AJAX
	Return to Discussion Resource Index
	Post New Resource
	Category: Computer & Technology

Post resources and earn money!

Related Resources

Fresher Jobs

Resources

Colleges

Meaning of TRIGGERS In PL/SQL

Responses

Post Feedback