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.

Does truncate table reset auto increment?

0 Answers  

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

Can we insert data into view?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

Enlist the data types that can be used in pl/sql?

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

What is the sql*loader? : aql loader

0 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

What are sql ddl commands?

0 Answers  

---