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
Can you create a synonym without having a table?
What is a sub query? Describe its types?
What is BBED in Oracle?
What is a package ? What are the advantages of package ?
How to define an oracle cursor variable?
How do I spool in oracle?
How to start a new transaction in oracle?
Can we create trigger on materialized view in oracle?
Can you drop an index associated with a unique or primary key constraint?
what is the difference between restoring and recovering?
What is merge in oracle?
How to list all user accounts in oracle?
What are the components of logical database structure in oracle database?
Is the After report trigger fired if the report execution fails ?
What is the string concatenation operator in oracle?
