What are the advantages of View

Security, Query Simplicity, Structural simplicity, Consistency, Data Integrity, Logical data independence, Performance, Update restrictions etc...

1.you can provide required column to user ex.if table(id,Name,City) n u want to show only Name,City then create view view_table as select Name,City from table ----execute-- Select * from view_table

1. We can query more than one table using views.(complex queries) 2. Hide columns and expose only selected columns. So its restricting access to view the complete table. 3.Inserts and updates are not allowed in views. So its read only mode and hence you can use this for look ups and readonly grids.