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 do you get column names only for a table (sql server)?
what are the differences between binary and varbinary? : Sql dba
What is the starting oracle error number?
What are the different sql commands?
How can you fetch common records from two tables?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what is the difference between join and union? : Sql dba
How to select unique records from a table?
What is database white box testing and black box testing?
How do you create a unique index?
What is sqlcommand?
What is percent sign in sql?
Can 2 queries be executed simultaneously in a distributed database system?
how many triggers are allowed in mysql table? : Sql dba
What is difference between table and view?
