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
What are the benefits of ordbms?
Explain rename?
How to check the server version in oracle?
How index is implemented in oracle database?
Explain the use of inctype option in exp command.
Explain the use of record option in exp command.
How to generate query output in html format?
What is the difference between sharding and partitioning?
What are operators in oracle?
How oracle handles dead locks?
How to connect to a remote server?
Explain what are clusters?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain an index?
How to load excel data sheet to oracle database
