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 rename an existing table?
How a database is related to tablespaces?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to create a single index for multiple columns?
What is the recommended interval at which to run statspack snapshots, and why?
How to synchronize 2 schema's objects?
How to get maxsal , minsal, ename department wise in single query
How to check your oracle database 10g xe installation?
What are the limitations oracle database 10g xe?
How to convert numbers to characters in oracle?
State and explain the different types of data models?
How can you use check constraints for self referential integrity?
How to create a new table in oracle?
How to call a stored function with parameters?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
