Answer / 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.

Answer / bmk

Both are database objects and it behaves diff.View doesn't
contain data and tied with sql.Trigger is an event,trigger
will create on table with after/before with DML operations.

Answer / vivekanandhan

view is used to minimize the complex query of table(s), thru view we can do insert,update,delete where as trigger is an event which will execute automatically when any DML operations provided against the table.

Can we write create command in the plsql block?if possible how?

2 Answers  

---

How to rename a table?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

How do you respond to dementia behavior?

0 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---

What is update query?

0 Answers  

---

Which are sql * plus commands?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---