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.

What is primary key secondary key alternate key candidate key?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What is a pl/sql block?

0 Answers  

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

what is a materialized view? : Sql dba

0 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are types of indexes in sql?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

Why is sql*loader direct path so fast?

0 Answers  

---