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
Give the advantages and disadvantages of clusters.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is concurrency in oracle?
How to start your 10g xe server?
List out the difference between commit, rollback, and savepoint?
What is an oracle recycle bin?
How to drop an existing table in oracle?
Can we create trigger on materialized view in oracle?
In which language oracle has been developed?
How much memory your 10g xe server is using?
What are the attributes of cursor?
How do you bind variables in oracle?
What are temporal data types in oracle?
How do I uninstall oracle client from windows?
How to see free space of each tablespace?
