Answer / swapna

We can use 'instead of triggers' for views.Using these
instead of triggers we can perform DML operations on a
complex view.In complex views we can not perform DML
operations.But using instead of triggers we can insert ,
delete,update from complex views.

Answer / kmbkrishnan

Instead of Trigger is also like the FOR trigger, which
are triggered at that time of Insert or update or delete.
The FOR trigger will be triggering After the
Insert / Update / Delete (DML) opreation is executed. But
the Instead of Trigger will be triggering while the DML
operation held and the DML operation is discarded.

Answer / suresh kumar somayajula

These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.

Thank you,
Suresh.

What is difference between pl and sql?

0 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

Is sqlexception checked or unchecked?

0 Answers  

---

What are character functions?

0 Answers  

---

How does pl sql work?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is a primary key? Explain

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

how to check myisam tables for errors? : Sql dba

0 Answers  

---

What is the primary key?

0 Answers  

---