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
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is SQL access advisor in Oracle?
Can we create database in oracle using command line ?
How to start an oracle instance?
master table and child table performances and comparisons in Oracle ?
How to create a new table in your schema?
Which environment variables are absolutely critical in order to run the OUI?
What are the common oracle dba tasks?
How different is ms access and oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How does Oracle guarantee data integrity of data changes?
What is meant by raw datatype?
what are the default admin accounts in Oracle 10g ?
What is an oracle data file?
How to change program global area (pga) in oracle?
