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.

define primary key & secondary key?

2 Answers  

---

How to write pl sql program in mysql command prompt?

0 Answers  

---

What is date functions?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

what are date and time data types in mysql? : Sql dba

0 Answers  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

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

2 Answers  

---