A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database.
The database trigger are executed either before or after our required code. By default it is executed after.
Example:CREATE [OR REPLACE ] TRIGGER trigger_name
{BEFORE |AFTER |INSTEAD OF}
{INSERT [OR] | UPDATE [OR] |DELETE}
[OF col_name]
on table_name
Subscribe to:
Post Comments (Atom)
-
Web Application:Any application which we can run in our web browser is a web application. Web Service:A web service is an Application Prog...
-
Amazon cloudfront offers a simple cost effective way to improve the performance, reliability and global reach of your entire website for s... -
p5.js is a JavaScript library which can be used by artists,designers,educators and beginners who want to code. Using p5.js we have a full se...
No comments:
Post a Comment