Interested to Buy Any Domain ? << Click Here >> for more details...
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
The select into statement is most often used to create backup copies of tables or for archiving records?
What does select count (*) mean in sql?
Why cross join is used?
What are the different types of sql commands?
What is cross join example?
If a cursor is open, how can we find in a pl/sql block?
What is before and after trigger?
What is pl sql variable?
What sql database should I use?
What are few of the schema objects that are created using PL/SQL?
Determine if oracle date is on a weekend?
What is insert command in sql?
what are set operators in sql? : Sql dba
What is break?
What is latest version of sql?
