Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 1 (Q.No. 13)
13.
In SQL, which command(s) is(are) used to enable/disable a database trigger?
Discussion:
6 comments Page 1 of 1.
David said:
4 years ago
Database triggers are procedures that are stored in the database and activated ("fired") when specific conditions occur, such as adding a row to a table.
You can use triggers to supplement the standard capabilities of the database to provide a highly customized database management system. For example, you can create a trigger to restrict DML operations against a table, allowing only statements issued during regular business hours.
You can use triggers to supplement the standard capabilities of the database to provide a highly customized database management system. For example, you can create a trigger to restrict DML operations against a table, allowing only statements issued during regular business hours.
Ravi said:
1 decade ago
Use the ALTER TRIGGER statement to enable, disable, or compile a database trigger.
The keyword is ALTER.
Note:
This statement does not change the declaration or definition of an existing trigger. To redeclare or redefine a trigger, use the CREATE TRIGGER statement with the OR REPLACE keywords.
The keyword is ALTER.
Note:
This statement does not change the declaration or definition of an existing trigger. To redeclare or redefine a trigger, use the CREATE TRIGGER statement with the OR REPLACE keywords.
Kalai batt said:
6 years ago
The trigger is a mechanism for altering humans for storing certain tasks automatically when certain conditions met.
Anil said:
1 decade ago
Alter trigger should be answer. If it is possible using Alter User, then explain, how?
Kowsalya said:
7 years ago
Thank you for explaining the answer @Ravi.
Sangita said:
1 decade ago
What is database trigger?
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers