View - what is the Advantage?

hisabari · New User Joined: 10 May 2005 Posts: 3

What is the difference while u are Inserting in to a table as well as
inserting into view to update the table. Ie., thru this view to update the
same table.

Eg. Emp is a table with eno,ename,esal
VEmp is the View , having the same structure and size of the Emp.
Table.

Now I am inserting first rec. to Emp table. And the another record is inserting in to the view. Okay what is the advantage while u are inserting this second record thru view to Table.

Pls. give me the advantages of View.

i413678 · Posted: Tue May 10, 2005 1:41 pm

Hi

Advantages of Views are:

1. it provides the data security.
2. the same table can be appeared as different for different users.
3. provides DOMAIN INTEGRITY with WITH CHECK OPTION.
4. provides to derive new attributes by using aggregate functions.

Cheers.................

pavankumar

hisabari · New User Joined: 10 May 2005 Posts: 3

Hi Pavan,

Thankx for ur nice Answer. But if u have a table with , u create a View with same column .(Ref the above Eg.) Now u are updating view. It will be updated in the Table also right??? then What is the Security. I am till confusion abt view in this case.

Can u explain me. And Pls Ans. my Above example also.

Cheers

sabari

vasanthanc · New User Joined: 01 Apr 2005 Posts: 58

Pavan has clearly explained the advantages of views. There is no need to create a view with all the fields and rows of a table and with no additional (for ex: aggrate function) columns. And in case, if you have such a view, then there is no difference, if you update a table directly or through the view

hisabari · New User Joined: 10 May 2005 Posts: 3

Thanx vasanth and Pavan,

I got some better idea about view in this case.

Cheers