Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaarthi v
Triggers are the database objects (Like Procedures) which
will be executed by the Database itself and cannot be
excuted by the user explicitly. The trigger can be written
to execute while inserting/ updating/ deleting a row.
Two types of triiger
ROW LEVEL TRIGGER
===============
Row Level triggers are FOR EACH ROW, that is, the trigger
is activated for each row that is inserted/updated/deleted.
STATEMENT LEVEL TRIGGER
=====================
Statement level triggers will execute the action specified
only once. (Will not consider the no. of rows being
inserted/updated/deleted)
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to create a stored procedure in oracle?
What are privileges and grants?
How to invoke the original export import utilities?
Briefly explain what is literal? Give an example where it can be used?
How can we find out the current date and time in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to recover a dropped table in oracle?
How index is implemented in oracle database?
What are the attributes that are found in a cursor?
Explain the difference between a procedure and a function?
What is the difference between count (*), count (expression), count (distinct expression)?
How to export data to a csv file?
What is the quickest way to export a table to a flat file?
What are the oracle differences between nvl and coalesce
How to omit columns with default values in insert statement in oracle?
