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
Why primary key is required?
What is a stored procedure in sql with example?
What is the life of an sql statement?
What is mdf ldf and ndf?
Define a temp table?
What do you think about pl/sql?
How to display Row Number with Records in Oracle SQL Plus?
What are sql constraints?
What is delimiter sql?
What view means?
How to select 10 records from a table?
Can triggers stop a dml statement from executing on a table?
What is normalization sql?
how can you create an empty table from an existing table? : Sql dba
Explain the difference in execution of triggers and stored procedures?
