Hi Shikar

You are wrong. We can update a view by using insert update delete statements.

A view from a single table can be updated where as a view from multiple tables can not be updated.

Thanks

Dev.

the meaning of view is snapshot of the table .

without disturbing the main table we done in view so we can perform the dml commnads in it.

i think u understood

view is collection of data but itis not stored in database.To simplfy the selected statements we can use view and itis snapshot for table

we can update view by using DML commands

Hi

I am shailendra

its my op.

yes

you can update the view

suppose you can create the view

create view v1 as select ename sal from emp

suppose you want to update the view according to salary

update v1 set ename 'shailendra' where sal 800;

Hello Shailendra

This is rahul.As per discussion on views. I want to share some thing. There are two types of views namely Simple and complex views.

U can perform DML operation on simple views which is based on single table and that view doesn't contain any single row function and any group by clause and it has to satiesfy integrity constraint also.

U can't perform DML operation on complex views becuase they are based on multiple table. U can achive this task by using Triggers(Instade of...).

If u have any suggestion on bellow discussion please send mail to rahul_omanwar@hotmail.com.

Thanks and regards

Rahul Omanwar

mob no : 9423612912