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 oracle use sql?

0 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

What is pl sql and why it is used for?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

How do you retrieve the last N records from a table?

10 Answers  

---

What does subquery mean in sql?

0 Answers  

---

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

Explain the components of sql?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---