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 start an oracle instance?
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is oracle latest version?
How to use values from other tables in update statements using oracle?
