Answer Posted / madhuri
Triggers are basically PL/SQL procedures that are associated
with tables, and are fired whenever a certain modification
(event) occurs. The modification statements may include
INSERT, UPDATE, and DELETE.
The general structure of triggers is:
CREATE [OR REPLACE]TRIGGER trigger_name
BEFORE/AFTER
INSERT/UPDATE/DELETE ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
...
END;
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Can you have more than one trigger on a table?
What is the difference between sql and t sql?
Explain select statements in sql?
How to read/write files from pl/sql?
What is the difference between joins?
Write a query to find the names of users that begin with "um" in sql?
Write a sql query to get the third highest salary of an employee from employee_table?
How can triggers be used for the table auditing?
What if we write return in procedure?
What is difference between stored procedures and application procedures?
How many types of privileges are available in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Where do we use pl sql?
how to get help information from the server? : Sql dba