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
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Hi Can any one tell me what are the API's used in requisition import.
What is private procedure oracle?
 How to use an oracle sequence generator in a mapping?
WHAT IS ecc 6.0
What is open database communication (odbc) in oracle?
Explain the types of exception?
Explain the use of log option in exp command.
How to set up autotrace for a user account?
types of indexes and the rationale behind choosing a particular index for a situation.
what is port in oracle? how is it related to database application.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is connection pool in oracle?
What is an oracle database table?
How to define a sub function?
