Answer Posted / rajesh venati

View are classified in to two types.
1. Simple View
2. Complex View

==>DML Operations are not possible in complex views, because,
if u create a view more than one table or
if u create a view using group function or
if u create a view using distinct keyword etc.,
those are called complex view.

If u want perform DML Operations on Complex Views, then we
will go for Instead of Trigger.

Through the Instead of Triggers we can perform DML
Operations on a Complex View.

Can we create a trigger on view?

481

---

How do you copy a table in sql?

557

---

what is the syntax used for partition in tsql? : Transact sql

529

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

497

---

What are sql indexes?

540

---

---

How can a pl sql block be executed?

526

---

How do you modify a trigger?

520

---

what are the drivers in mysql? : Sql dba

549

---

what is the difference between cluster and non cluster index? : Sql dba

548

---

what is msql? : Sql dba

560

---

how to load data files into tables with 'mysqlimport'? : Sql dba

515

---

How to process query result in pl/sql?

555

---

Why should I use postgresql?

557

---

What is varchar example?

568

---

what is data control language? : Sql dba

582

---